Home » Developer & Programmer » Forms » Enter Query and Execute Query (developer 6i database 10g window 2003 server )
Enter Query and Execute Query [message #406668] Fri, 05 June 2009 05:13 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Hellow all

i have 2 Blocks one block type is Form and other type is Tabular

in form type block the no of record show 1

and in Tabular block no of record show 10

i write the trigger on Tabular block item 1

GO_BLOCK('BLOCK3');
ENTER_QUERY;
:CATAGORY_NO :=:PARTY_CODE;
EXECUTE_QUERY;


its execute the record which category no = party code but when i save my record its save a duplicate record i want to update my this record as we done with enter query and execute query

Hope you genius guys understand

Regards


Shahzaib ismail
Re: Enter Query and Execute Query [message #406672 is a reply to message #406668] Fri, 05 June 2009 05:20 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Your code, actually, does nothing useful. You can't code querying the way you tried because - when form enters query mode (ENTER_QUERY in your example), it waits for user's intervention so you have to manually enter search criteria and manually execute query.

What you might do is to use the PRE-QUERY which which would set
:CATAGORY_NO := :PARTY_CODE;
and then execute query. Or, you might use SET_BLOCK_PROPERTY with the DEFAULT_WHERE (or ONETIME_WHERE) clause.
Re: Enter Query and Execute Query [message #406676 is a reply to message #406668] Fri, 05 June 2009 06:02 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Thanks for your reply Little foot


But i need when user double click then block which is in form type go to enter query and execute query where catagory_no=party_code


Regards


Shahzaib ismail
Re: Enter Query and Execute Query [message #406691 is a reply to message #406676] Fri, 05 June 2009 06:56 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid that there's nothing I'd like to add about the issue. Everything is in my previous post.
Re: Enter Query and Execute Query [message #407657 is a reply to message #406676] Thu, 11 June 2009 00:14 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Just use the standard master-detail logic and move on.

David
Previous Topic: how do i disable smartbar icon?
Next Topic: shortcut forms dont run (merged 2)
Goto Forum:
  


Current Time: Mon Dec 05 07:14:41 CST 2016

Total time taken to generate the page: 0.04870 seconds