TOraSQL doesn't get comitted

kurtbilde · Post by **kurtbilde** » Wed 02 Dec 2009 23:32

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

Plash · Post by **Plash** » Fri 04 Dec 2009 09:00

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

kurtbilde · Post by **kurtbilde** » Tue 15 Dec 2009 17:58

Nope!

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

-Kurt

Plash · Post by **Plash** » Thu 17 Dec 2009 08:55

Call the Refresh method of TOraTable to refresh its data.