odac 6.90.0.53, TSmartQuery, Master detail=> No updates!

[albourgz]

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

Code: Select all

Table2->ApplyUpdates();Table1->ApplyUpdates();

=> 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:

Code: Select all

	FDM->OurDB->ApplyUpdates();
	FDM->OurDB->Commit();

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

[kurtbilde]

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

[albourgz]

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

[Plash]

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.

[albourgz]

has been sent.