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
vijayendra.k
Messages: 11
Registered: August 2006
Junior Member
hi,
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
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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

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


Current Time: Mon Dec 05 21:14:25 CST 2016

Total time taken to generate the page: 0.06473 seconds