how to disable a particular record in a block [message #135425] |
Wed, 31 August 2005 09:20 |
ramisy2k
Messages: 150 Registered: April 2005
|
Senior Member |
|
|
Hi
i am form in which there is a db block.the block shows 12 records at a time...also the block has 12 db items but only 8 are on the canvas..4 four of these eight items are display items
My requiremnt is that if the value in..say..item_5 is 17 at any number of record then the particlar record becomes disabled. is it possible to achieve in forms 6i...
i would be extremly grateful if any one could work that out for me..as this is the requirement of my programme..
thanks in advance,
regrard,
Asim.
|
|
|
Re: how to disable a particular record in a block [message #135513 is a reply to message #135425] |
Wed, 31 August 2005 19:08 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Search this forum for 'disable' and 'set_item_instance_property'. There are quite a few threads but it has all been answered before.
Short answer: in When-New-Record-Instance test your condition and if true then use SIIP to turn 'enable' off. Remember that you need to turn 'enable on and then 'update' on as the disable turns update off.
Update: karthikraj is correct. It should be the Post-Query trigger. Sorry.
David
[Updated on: Wed, 31 August 2005 23:38] Report message to a moderator
|
|
|
|