RLIST Syntax Check Oddity (OpenInsight Specific)
At 12 FEB 2002 08:22:17AM Richard Guise (Tornado Property Systems Ltd.) wrote:
My T-List report writer has separate prompts for WITH clause and BY clause (these have to be separate for an option for simultaneous reporting from live & archive files - another story!).
In both I use the RLIST syntax check with target code 7 in a user-specified validation routine.
This has worked fine at all our sites for several years. However, last week editing the BY clause in one particular report, the validation seemd to hang - but in fact was just taking an age. Debugs showed this was happening within the RLIST routine and not elsewhere. In the meantime the WITH was fine as were BYs in other reports.
The only feature of this report was that the data file had about 16,500 records (normally our data files are much smaller but very complex). I tried changing the target code to 5 and it took much the same time.
I've now written my own BY checker (much simpler than the WITH syntax!) - so the problem has been by-passed.
Any comments??