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

Report message to a moderator

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: 10181
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

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 20:23:54 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.