Loading

change behaviour of all editable fields in a control

pbecker

If you edit a field in oracle Forms the record in the database will be locked, so nobody can change ore edit this field.
Now I want to implement this behaviour in .net.
I want all controls in which I can edit something (Text, Check, list box ore dbtables...) to go to the database and lock the record.
Does someone have any Ideas how to do this in c#.net? User controls? ore is there a better way?
thanks
Paul
ps: sorry for my bad english

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

pbecker18y ago
thank you for your reply!
Is there a way (beside user control) to define a look and feel of the controls and the whole form?
thanks
Paul
+1
Sateesh Arveti18y ago
Hi,

Normally,you will be using an select stmt to get the row contents to populate the editable controls.so,you can use SELECT FOR UPDATE stmt to lock the records,while getting the row.The syntax is :
```
SELECT *
FROM   
FOR UPDATE WAIT 30

or 

You have to lock the table by using LOCK TABLE stmt.
```
+1