OraFAQ Forum: Forms » Enter Query and Execute Query

Home » Developer & Programmer » Forms » Enter Query and Execute Query (developer 6i database 10g window 2003 server )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Enter Query and Execute Query [message #406668]

Fri, 05 June 2009 05:13

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Enter Query and Execute Query [message #406672 is a reply to message #406668]

Fri, 05 June 2009 05:20

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Enter Query and Execute Query [message #406676 is a reply to message #406668]

Fri, 05 June 2009 06:02

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Enter Query and Execute Query [message #406691 is a reply to message #406676]

Fri, 05 June 2009 06:56

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Enter Query and Execute Query [message #407657 is a reply to message #406676]

Thu, 11 June 2009 00:14

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Just use the standard master-detail logic and move on.

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 21:56:28 CST 2024