At 07:14 PM 4/18/2008, Steve Martin wrote:
Advice taken. Thank you. I am not naming tables or view with SYS_ but I am naming some forms, reports and stored procedure with SYS_. Still a risk?
I would suggest not to use SYS_ names, even for Forms, Reports, Labels or External Form Files.
And, your suspicion makes sense. The error only occurs when running from the application which uses the ARRANGE option which would require the table/view to exist during the parsing of the command. I suppose the only fix in this instance is to create the temp view prior to calling the form rather than in the On Before Start eep. Agreed?
R:BASE syntax for using the ARRANGE tableview BY ... command is first validated (enforced) prior to bringing up the multi-table form or generating a multi-table report with sub-reports. In your specific scenario, you'll have to assure the existence of all "slave tables" used in ARRANGE tableview BY ... clause prior to using the ARRANGE tableview BY ... command a the R> prompt or in a command file. That's all there is to it! Very Best R:egards, Razzak.
