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..

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you call "the passed criteria" and how do you set it?

Report message to a moderator

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 .

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please post the code you have in your 'pre-query', 'key-entqry' and 'key-exeqry' triggers.

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 11:29:52 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.