Home » Developer & Programmer » Forms » enabling disabling records
enabling disabling records [message #166948] Mon, 10 April 2006 07:55 Go to next message
nirmalnarayan
Messages: 261
Registered: April 2005
Location: India
Senior Member
Hi,

I have a datablock in which for a particular column i need to enable or disable the rows in the column depending on some value in a database value. how can we enable a particular row in the column.

If i use set_item_property the whole column gets disabled or enabled, how can i do it record wise.

Thanks,

Nirmal
Re: enabling disabling records [message #166949 is a reply to message #166948] Mon, 10 April 2006 07:59 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You're looking for SET_ITEM_INSTANCE_PROPERTY. This allow you to set INSERT_ALLOWED, UPDATE_ALLOWED at record level.

MHE

Re: enabling disabling records [message #167040 is a reply to message #166948] Mon, 10 April 2006 23:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Be aware that disabling an item also turns off update, insert, and navigate. Read the 'matrix' under 'set_item_instance_property' in the reference manual for the order in which they have to be turned back on.

David
where i give code and how i use [message #171210 is a reply to message #166949] Tue, 09 May 2006 01:33 Go to previous messageGo to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
sir please give me idea where i put that code and you i use
SET_ITEM_INSTANCE_PROPERTY for INSERT_ALLOWED, UPDATE_ALLOWED

please give my use process

thanking you
Re: where i give code and how i use [message #171226 is a reply to message #171210] Tue, 09 May 2006 02:01 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Typically, in Pre-Text-Item trigger as When-New-Item-Instance fires when you are IN the item. Hence, if the field has been disabled you won't get the WNII to fire, but PTI will (I think).

Test it and see.

David
Previous Topic: Disable one or two records from a multi record block
Next Topic: Database block on a view
Goto Forum:
  


Current Time: Fri Sep 20 07:29:03 CDT 2024