DB_ commands: don\'t tell me they each do an automatic commit?!
I am trying to write a database transaction -- deleting all rows from one table, then copying the rows from another table into the first. I did so, and then coded a DB_ExecuteSql( "COMMIT") statement, since I noticed that Silk didn't have a separate DB_Commit statement. (shoulda known right there that there would be problems!) Anyway, I had a extraneous close-paren in the INSERT command, which raised an exception. When I looked at the database through Toad, I saw that all the rows had been deleted from the first table!
Is it what I fear? Does Silk commit after each issuance of a DB_ command?
a software developer interested in quality software