Re: How do I capture FRM-40505 when executing query?
Date: Tue, 16 Mar 2004 21:18:57 GMT
Message-ID: <5bK5c.37630$084.2422822_at_phobos.telenet-ops.be>
Why should you hide the error?
[Quoted] 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 Tue Mar 16 2004 - 22:18:57 CET