Home » Developer & Programmer » Forms » how to find errors occured during execute_query
how to find errors occured during execute_query [message #297351] Thu, 31 January 2008 04:00 Go to next message
Messages: 11
Registered: August 2006
Junior Member
i have 2 forms when we click on the record present on first form
it will move to the second form and i popoulate fields in second form using execute_query but for certain data the execute_query fails (mean to say it doesn't populate the data even der is data in table)and no errors are dispalyed is der any way to find wat error occured during execute_query,because the fields are populated if i replace select statement in place of execute_query,i want execute qry not to be replaced so how do i know wat error occured in execut_qry and how many records it fetched.

thank u
Re: how to find errors occured during execute_query [message #297472 is a reply to message #297351] Thu, 31 January 2008 21:55 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I infer from your post that you are manually populating your block. Do not write your form this way. Use the default behaviour to do it for you. Access the information from the first form via globals or parameters in the When-New-Form-Instance trigger and use it to populate the 'default_where' of your query block. To find out how many records will be retrieved get the 'query_hits' for the query block. Look at http://www.orafaq.com/forum/m/113558/67467/?srch=query_hits+count_query#msg_113558

Previous Topic: import from excel
Next Topic: how to moineteing the updating of data
Goto Forum:

Current Time: Thu Aug 17 22:21:47 CDT 2017

Total time taken to generate the page: 0.08716 seconds