OraFAQ Forum: Forms » Execute

Home » Developer & Programmer » Forms » Execute_query problem

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

Execute_query problem [message #488743]

Mon, 10 January 2011 22:28

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I create databalock - LC_REQ_PO_ITM_DTLS

In design time Insert and update allowed for that block - YES.

While i execute query, i write procedure like this

GO_BLOCK('LC_REQ_PO_ITM_DTLS');
EXECUTE_QUERY;
SET_ITEM_PROPERTY('pb_item_cd', enabled, property_false);
SET_BLOCK_PROPERTY('LC_REQ_PO_ITM_DTLS',INSERT_ALLOWED, PROPERTY_FALSE);
SET_BLOCK_PROPERTY('LC_REQ_PO_ITM_DTLS',UPDATE_ALLOWED, PROPERTY_FALSE);

but when i press execute button , then data comes properly on that bloack..but i click on that block, error comes like this -
'You can not create record here '.....and data disappearing..

Please help to solve this problem...

Report message to a moderator

Re: Execute_query problem [message #488754 is a reply to message #488743]

Tue, 11 January 2011 00:14

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

Senior Member
Account Moderator

Where did you put the code?
Where did you click (on that block)? Into an empty record? If so, well, you can't do that (as you can't create a record there (that's what you told Forms to do)).

Report message to a moderator

Re: Execute_query problem [message #488756 is a reply to message #488754]

Tue, 11 January 2011 00:20

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I click on that block. (data block). and on that block there is no empty record..

Report message to a moderator

Re: Execute_query problem [message #488771 is a reply to message #488756]

Tue, 11 January 2011 02:24

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Got any when-new-record/block/item-instance triggers?

Report message to a moderator

Previous Topic:	web.show_document parameter passing to Report9i
Next Topic:	Prcatical Explaination about function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:47:41 CDT 2024