Home » Developer & Programmer » Forms » execute_query in forms 10g
execute_query in forms 10g [message #256296] Fri, 03 August 2007 14:12 Go to next message
rishi1979
Messages: 36
Registered: November 2006
Member
I have a problem in using EXECUTE_QUERY in KEY-EXEQRY in forms 10g instead of fetching one record for the passed criteria it fetches all the records.

any help would be much appreciated..
Re: execute_query in forms 10g [message #256297 is a reply to message #256296] Fri, 03 August 2007 14:14 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you call "the passed criteria" and how do you set it?
Re: execute_query in forms 10g [message #256299 is a reply to message #256296] Fri, 03 August 2007 14:20 Go to previous messageGo to next message
rishi1979
Messages: 36
Registered: November 2006
Member
passed criteria here means like if i have a field emp no and ename
and i am passing Ename as SMITh in Enter-query mode so in theory it should query all the records
with the EName - 'SMITH' ,
but my problem is that its querying all the records which exists in EMP table .
Re: execute_query in forms 10g [message #256609 is a reply to message #256299] Mon, 06 August 2007 02:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the code you have in your 'pre-query', 'key-entqry' and 'key-exeqry' triggers.

David
Previous Topic: Java Bean clock for Oracle Forms 10g
Next Topic: Library attachment in developer6i
Goto Forum:
  


Current Time: Thu Dec 08 06:38:48 CST 2016

Total time taken to generate the page: 0.09990 seconds