OraFAQ Forum: Forms » going into query mode problem

Home » Developer & Programmer » Forms » going into query mode problem (8i, forms6i, xp)

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

going into query mode problem [message #318855]

Thu, 08 May 2008 04:30

rzkhan
Messages: 370
Registered: March 2005

Senior Member

hi...all

I have form. In one of the block the REQUIRED property of one text item set to YES.

My problem is when I press F8 (Execute Query) to get all records displayed.
The cursor moves to the text item for which the REQUIRED property has been set to YES.
and execute query does not work.

Please help me handling the situation.

riaz

Report message to a moderator

Re: going into query mode problem [message #318892 is a reply to message #318855]

Thu, 08 May 2008 07:01

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

Senior Member
Account Moderator

You must have done something else; because, it doesn't matter whether the "Required" item property is set to Yes if there were no changes in the block.

So, first you should find out what (which trigger, for example) did some changes. Decide whether it should (or should not) be done and - possibly - fix it.

Otherwise, you might code your own KEY-EXEQRY trigger as

execute_query(no_validate);

or even

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

Report message to a moderator

Re: going into query mode problem [message #318913 is a reply to message #318855]

Thu, 08 May 2008 07:44

rzkhan
Messages: 370
Registered: March 2005

Senior Member

thanks. it solved my problem. Howeve , I am checking there are some WHEN-VALIDATE-TRIGGERS
on some text items that may cause the problem.

thank you.
riaz

Report message to a moderator

Previous Topic:	Can't paste OS clipboard into Web ORACLE FORM
Next Topic:	Is LOV updated every time the form runs ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 13:24:51 CDT 2025