----- Original Message ----- From: "Marc Delisle" DelislMa@CollegeSherbrooke.qc.ca
good idea. However is it possible to check for locks: "Not transaction-safe; you will get an error if you have an active
transaction or an active table
lock. "
I don't know yet, I'm going to browse a bit through the docs... But if not, it should work like this: If TRUNCATE fails, try DELETE instead.
Alexander