Problem with TOracleQuery

[JediDan]

Hello,

I have a TOracleQuery through which I am trying to using INSERT or DELETE statements, but nothing happens when I run the program. When I use SELECT statements, everything seems fine.

Here's what I have:

OraQuery := TOracleQuery.Create(Self);

with OraQuery do begin
Session := Form1.OracleConnection;
SQL.Clear;
SQL.Add('DELETE FROM MyTable');
Execute;
end;

This is just an example, but it doesn't work and I'm completely stuck. Any help is appreciated.

I'm using Delphi 5 Enterprise, Oracle 8.1.6, DOA 3.4.6.1 evaluation version.

Thanks.

 

[jpickup]

Are you commiting the transaction (Commit method of TOracleSession)?

 

[JediDan]

Thanks... I new it was something simple.