Devart Forums

Using bcb 2009.
I have a TOraSession with autocommit to false.
I have 2 TSmartQueries, 2 TCRDBGrid, master child.
Setting TSmartQuery.CachedUpdates to true, TSmartQuery.Autocommit to false
A Button with => Modify master, change a value, click button, I get Exception:
---------------------------
Debugger Exception Notification
---------------------------
Project Model.exe raised exception class EOraError with message 'ORA-01086: le savepoint 'LOCK_TABLE1' n'a jamais été établi'.
---------------------------
Break Continue Help
---------------------------

If I don't set a master child, and use only Table1, it works.

I also tried to disable CachedUpdates and to put in button:
Where FDM is dataModule and OurDB the TOraSession1.

In this case,
* if I use only one table, it works.
* if I use a master child table only one table, no error occur, but changes are not commited!!!!!

I think this problem is due to v6.90.0.53.

Regards,
Alain

Hi Alain,

I have had simmelar expirence with tOraTable...

Could you try to set the LockMode to lmNone and do a re-run with the two tables... I'll bet you doesn't get an Ora-1086...

Mine occures when I call a TOraTable.Cancel on a table in Insert-mode, so I guess that there is issues with table that have constraints set.

-Kurt

no error message when doing session->ApplyUpdates/Commit. But changes are not committed! Doing a refresh displays the old value.

We could not reproduce the problem. Please send to support*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

has been sent.