>>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
Thanks - but I still know whether this applies to the current version. There are savepoints now. So even if there's a max of one transaction level, the question remains how do I know what is it, zero or one?