Is it possible to manage multiple db transactions at the same time?
May seem like a strange questions, but I have some long logic using a db transaction, but while that logic is being processed, I have some database inserts for debuging. If the parent transaction fails, none of my debug inserts are inserted either.
Thanks,
Ed
[QUOTE=emilner;40192]Is it possible to manage multiple db transactions at the same time?
May seem like a strange questions, but I have some long logic using a db transaction, but while that logic is being processed, I have some database inserts for debuging. If the parent transaction fails, none of my debug inserts are inserted either.
Thanks,
Ed[/QUOTE]
I’m not sure but… Multiple db transactions would mean that you have nested transactions. It depends on your database if that’s allowed. In MySQL you need to fiddle with savepoints. Although you have an execsql to perform transactional statements there’s a sc_commit_trans in scriptcase. This macro allows you to commit depending on a connection. So you could try to create two sessions. But it all sounds very messy to me …