Table Lock vs. Row Lock

[M.Schmidt-E.]

Hello,
how to implement a row lock?
I use a "select [fields] from [table] for update" in TSmartQuery.
Properties of tSmartQuery:
AutoCommit=False
Lockmode=lmNone
FetchAll=True
Properties of TOraSession:
not in transaction
Autocommit=False
Pooling=False

After Editing and Close the Query, the Table is locked by oracle.

D2009 and ODAC 6.70.0.42

Can anyone help me?
thx
Mathias

[Challenger]

You should commit transaction in order to release locked records. Please note that when executing SELECT ... FOR UPDATE command without WHERE condition you lock all records. It is better to use the LockMode property for row locking. For more information please refer to the Odac help.

[M.Schmidt-E.]

My test:
My steps:
1. open TOraSession, connection is not in transaction
2. select [columns] from [Table] where [statement] into TSmartQuery
3. TSmartQuery.LockMode:= lmLockDelayed
4. TSmartQuery.Autocommit:= False
5. open TSmartQuery
6. edit Data in Grid (tcxgridDBTableView, Component by DevExpress)
7. Post Data
8. Close TSmartQuery.

Table is locked, but why?
Mathias

[jfudickar]

You must commit the changes in the database after all.

Session.Commit;

Greetings
Jens