OraFAQ Forum: Forms » enabling disabling records

Home » Developer & Programmer » Forms » enabling disabling records

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

enabling disabling records [message #166948]

Mon, 10 April 2006 07:55

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

Report message to a moderator

Re: enabling disabling records [message #166949 is a reply to message #166948]

Mon, 10 April 2006 07:59

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

Report message to a moderator

Re: enabling disabling records [message #167040 is a reply to message #166948]

Mon, 10 April 2006 23:57

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

Report message to a moderator

where i give code and how i use [message #171210 is a reply to message #166949]

Tue, 09 May 2006 01:33

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

Report message to a moderator

Re: where i give code and how i use [message #171226 is a reply to message #171210]

Tue, 09 May 2006 02:01

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 08 17:41:44 CST 2025