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?

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?

Steve

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A.
Razzak Memon
Sent: Friday, April 18, 2008 2:12 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Can't present?

At 11:53 AM 4/18/2008, Steve Martin wrote:

>I get this error when I call a form whose temp view is created in its'
>On Before Start eep.  And, it only appears when I call it from my
>application.  It does not appear when the form is called from the R>
>or run within form designer.

Steve,

You should avoid naming your Tables or Views starting with "SYS_".
Not a good idea.

Having said that, the resulting -ERROR- message has to do with a
missing or un-defined table/view name, used in ARRANGE BY clause.

Hope that gives you some blue's clues!

Very Best R:egards,

Razzak.


Reply via email to