>Tired of googling it out, can't find whether it exists or is called something else.
>
>How do I know whether I have a transaction started in MySQL? I need an equivalent to TSQL's @@TRANCOUNT or VFP's TxnLevel().
Maybe I'm reading it wrong:
"In MySQL you cannot nest transactions. If you issue a BEGINstatement for agiven user while that user has a pending transaction, MySQL will treat it as aCOMMITfollowed by a BEGIN. In other words, MySQL allows individual users to per-form only sequential transactions.
NOTEMySQL does not support save points as do some other data-bases.You can only commit or roll back a complete transaction."
Source: dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf
Cetin