OraFAQ Forum: Forms » Make a data block read only

Home » Developer & Programmer » Forms » Make a data block read only

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

Make a data block read only [message #361831]

Fri, 28 November 2008 03:36

SUHAS22845
Messages: 51
Registered: August 2008
Location: BANGALORE

Member

Hi,

Can any one please tell me how to make a data block read only, ie in a data block i have around 20 columns and i have to make this data block read only. can any one please help me out with this.

Report message to a moderator

Re: Make a data block read only [message #361858 is a reply to message #361831]

Fri, 28 November 2008 05:03

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

Senior Member
Account Moderator

SET_BLOCK_PROPERTY('block_name', update_allowed, property_false)

might be one way to do that.

Another one is to select all columns, open their (multiple selection) Property Palette, visit "Database" node and set Update and Insert Allowed properties to "No".

Or, you might call a form in query mode as

CALL_FORM('form_name', query_only)

It might do the job if there's only one block in a form.

Report message to a moderator

Re: Make a data block read only [message #362150 is a reply to message #361831]

Mon, 01 December 2008 03:42

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Are you fetching data to the data block when opening your form? Is any new insertion allowed?
If no insertion is allowed, then you have to take this case into consideration also, else, your datablock is no more "a read-only datablock".

Rajy

Report message to a moderator

Previous Topic:	count length of a field
Next Topic:	ATT colum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 19:40:33 CDT 2025