Home » Developer & Programmer » Forms » disallowing updates for particular rows in update mode
disallowing updates for particular rows in update mode [message #86067] Fri, 27 August 2004 07:13 Go to next message
subhasish
Messages: 33
Registered: May 2000
Member
I have a form whose fields fetched are like

transferd empid intime outtime hrsworked
y 1 7.3 16.3 9
n 2 7.3 16.3 9
y 4 7.3 16.3 9
n 8 7.3 16.3 9
y 3 7.3 16.3 9

Now I want is if transfered is 'y' then that particular row should NOT get updated by the end user, at the screen level ie. before commit_form.otherwise can be updated. Best is as soon as the end-user select the row and try to update alert message will come, thus disallowing him/her.Kindly let me know how this can be accomplished.

Thanks
Subhasish

Report message to a moderator

Re: disallowing updates for particular rows in update mode [message #86081 is a reply to message #86067] Sun, 29 August 2004 01:28 Go to previous messageGo to next message
omar
Messages: 19
Registered: February 2002
Junior Member
You can make a loop for all the records in the block and then user SET_ITEM_INSTANCE_PROPERTY(UPDATE_ALLOWED,PROPERTY_FALSE)

NOTE: CHECK THE HELP IN FORMS BUILDER FOR FURTHER INFORMATION AND EXAMPLES

Report message to a moderator

Re: disallowing updates for particular rows in update mode [message #86100 is a reply to message #86067] Tue, 31 August 2004 13:54 Go to previous message
Zain
Messages: 30
Registered: October 2003
Member
You may want to use set-item-instance-property built-in on transfered field. Create a trigger (WVI or when-new-item-instance) and use the built-in. Set the item's update property to false.

Report message to a moderator

Previous Topic: How the form gets loaded into the buffer,internally how it connects with databas
Next Topic: COMMIT_FORM sequence of events
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 09:13:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.