Hi,

I am using VB6.

cn.open DSN,UID,PWD
cn.BeginTrans
cn.Execute "DELETE FROM tTABLE_D"
cn.Execute "DELETE FROM tMASTER_D"
cn.CommitTrans
cn.close

After I execute this statement, I still able to see the data.
But when I quit the software, re-Run and view Report, No data was
found.

Is there something wrong with my SQL statement? Why the DMLs were
not affect my data UNTIL the software quit.
I am using Firebird 2.1.
Thank you.