Home » Developer & Programmer » Forms » Make a data block read only
Make a data block read only [message #361831] Fri, 28 November 2008 03:36 Go to next message
Messages: 51
Registered: August 2008


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.
Re: Make a data block read only [message #361858 is a reply to message #361831] Fri, 28 November 2008 05:03 Go to previous messageGo to next message
Messages: 20847
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.
Re: Make a data block read only [message #362150 is a reply to message #361831] Mon, 01 December 2008 03:42 Go to previous message
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".

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

Current Time: Fri Oct 28 05:41:37 CDT 2016

Total time taken to generate the page: 0.08563 seconds