Home » Developer & Programmer » Forms » enable disable
enable disable [message #227081] Tue, 27 March 2007 05:12 Go to next message
u263066
Messages: 47
Registered: March 2007
Member
how to make entire block not updatable if some of column of block is have some condition.

let say i have emp sal tab, and if sal block has a column status and does have 3 values like Submitted, paid,New.
Then what is best to make these consitions
Case 1:when Sumbitted:
Update No

case 2: when Paid
Update NO


case 3: New
Update Yes
Insert NO

any help
Re: enable disable [message #227280 is a reply to message #227081] Tue, 27 March 2007 19:50 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
But what if you have other records in the block that have a different value? Are you talking a detail only canvas or the detail block in a master/detail relationship on the canvas and using the information from the master block to set the detail characteristic?

David
Previous Topic: text box question
Next Topic: export from txt file to oracle table
Goto Forum:
  


Current Time: Sat Feb 08 21:27:57 CST 2025