Devart Forums

Hi,

Using the latest version of ODAC (6.90.0.53) and TOraSQL with AutoCommit set to true on both the TOraSQL and TOraSession. In directMode I use this code:

OraSQL.Sql.Clear;
OraSQL.Sql.add('DELETE FROM FAGBESK_STUDIE_ELEMENT WHERE STUDIE_ID = :SletID ');
OraSQL.params[0].value := StudieID;
OraSQL.execute;

Doesn't seem to be comitted - even a TOraSession.commit; doesn't seems to help... any clues?

-Kurt

Maybe Oracle did not find a row that corresponds to the condition in your DELETE statement. So no row is deleted.

Nope!

It seems like TOraTable isn't aware of the update made though the same TOraConnection..... So the TOraTable isn't in sync...

-Kurt

Call the Refresh method of TOraTable to refresh its data.