Re: How do I capture FRM-40505 when executing query?

It turned out, after checking out the SQL the system was generating, that the validation was going on at 3 different places. Two were deleted and now it is running great. No more FRM-40505 error.

"Luc Gyselinck" <Luc.Gyselinck_at_nospampandora.be> wrote in message news:<5bK5c.37630$084.2422822_at_phobos.telenet-ops.be>...
> Why should you hide the error?
> Either the user has done something wrong, or the developer did something
> wrong.
> FRM-40505: ORACLE error: means that the SQL generated by forms is not
> correct: columns that are marked as database are not table/view columns, the
> order by, the where clause is not correct, etc. etc. Use the 'Show Error' in
> the menu to view the SQL behind the query. We, developers, use this
> 'feature' to view the SQL of the query: force an error, view the error and
> you see the SQL...
>
> "M Hamilton" <mhamilton_at_usgs.gov> wrote in message
> news:7ce65461.0403160720.66c8799d_at_posting.google.com...
> > Am working in Designer 6i Forms. After entering a Query, then pressing
> > F8 to execute, I get the FRM-40505: ORACLE error: Unable to perform
> > query. I have tried coding the Application Logic Events for ON-ERROR
> > and ON-MESSAGE at the form level and module component level to capture
> > this. But, have had no luck. Can you help me capture this
> > error/message/alert so that the user will not see it? Thanks, Maggie
Received on Thu Mar 18 2004 - 15:37:42 CET