OraFAQ Forum: Forms » Execute

Home » Developer & Programmer » Forms » Execute _query

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

Execute _query [message #487859]

Mon, 03 January 2011 00:04

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I had a problem with execute query...

i made a data block...e.g. lc_req_po_itm_tac_dtls

when i do excute query on that block, all data dispalyed....but problem is user can edit this this data...so to avoid edit i write this code after excute_query

set_block_property('lc_req_po_itm_tac_dtls', INSERT_ALLOWED, PROPERTY_FALSE);

set_block_property('lc_req_po_itm_tac_dtls', UPDATE_ALLOWED, PROPERTY_FALSE);

but when i did this code....only last item shown on my data block insted of all records shown..

i dont get idea...how to displayed all records and user can't edit this records...

Report message to a moderator

Re: Execute _query [message #487890 is a reply to message #487859]

Mon, 03 January 2011 04:10

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

Senior Member

Why don't you just set the properties in the property palette?

Report message to a moderator

Re: Execute _query [message #487894 is a reply to message #487890]

Mon, 03 January 2011 04:38

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I set property pallete for that block..

Insert_allowed - true;
insert_allowed - true;

but when data view, if i forcefully set property false...mentioned problem arise...

Report message to a moderator

Re: Execute _query [message #487915 is a reply to message #487894]

Mon, 03 January 2011 05:29

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

Senior Member
Account Moderator

Cookiemonster said that you should set INSERT and UPDATE ALLOWED properties in Property Palette window to FALSE.

Report message to a moderator

Previous Topic:	Setting of Urdu language
Next Topic:	GO_RECORD performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:53:19 CDT 2024