Announcement

Collapse
No announcement yet.

db transactions

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • db transactions

    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

  • #2
    Originally posted by emilner View Post
    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
    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 ...
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X