OracleDataset

[nodari]

i can't edit data in dbgrid, error message is "record is locked by another user".
no another users are working, query is:
"select d.rowid, d.* from dest d
for update of d.code"

thank you

 

[Marco Kalter]

The for update clause will lock all records, so if this dataset is opened twice from 2 different Windows processes, you're in trouble. I could imagine that the dataset is opened at design-time in the Delphi/C++Builder IDE, in which case you cannot run your application.

Remove the for update clause, unless you really want to lock all records.

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 12 July 2002).]

 

[nodari]

I try without for update and also by adding for update in runtime, but the same error is occur.
read only properties of oracledataset and dbgrid->column is false. error is ocured when I'm running the application without C++ Builder environment (app.exe)

 

[Marco Kalter]

You can use the Oracle Monitor to verify the query that leads to this error message. If all is well a "select ... for update nowait" is executed, which leads to an "ORA-00054 resource busy and acquire with NOWAIT specified" exception. This would indicate that the record is in fact locked.

------------------
Marco Kalter
Allround Automations