OraFAQ Forum: Forms » how i avoid this window and directly fetched date

Home » Developer & Programmer » Forms » how i avoid this window and directly fetched date

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

how i avoid this window and directly fetched date [message #161749]

Tue, 07 March 2006 00:13

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master

sir i have three options button when i select anyone then my query change and fatch new data
but before fetching data system show new windows with this message

Do you want to save the changes you have made ?

with yes / no /cancel button

sir how i avoid this window and directly fetched date

or how bypass this message
please give me idea

Report message to a moderator

Re: how i avoid this window and directly fetched date [message #161791 is a reply to message #161749]

Tue, 07 March 2006 03:58

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can bypass it by actually save/commit the data prior to invoking another query. Search the board for your other options.

[Updated on: Tue, 07 March 2006 03:58]

Report message to a moderator

Re: how i avoid this window and directly fetched date [message #161799 is a reply to message #161791]

Tue, 07 March 2006 04:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you only queried data dnd didn't change anything, you also might try to "fool" Forms by letting it know that there's nothing to commit.

To do so, write a POST-QUERY trigger on block level which would have such a line:

set_record_property(:system.trigger_record, 'DEPT', status, query_status);

... where 'DEPT' is block name.

Report message to a moderator