Home » Developer & Programmer » Forms » enable disable
enable disable [message #227081] Tue, 27 March 2007 05:12 Go to next message
Messages: 47
Registered: March 2007
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
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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?

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

Current Time: Tue Oct 25 07:15:44 CDT 2016

Total time taken to generate the page: 0.12638 seconds