In MySQL transactions cannot be nested. There are several commands that cause an implicit autocommit, as if the COMMIT statement was issued. One of them is BEGIN or START TRANSACTION (they do the same thing and their VFP equivalent is BEGIN TRANSACTION).
On Wed, Apr 7, 2010 at 4:51 PM, Stephen Russell <[email protected]>wrote: > On Wed, Apr 7, 2010 at 8:31 AM, MB Software Solutions, LLC > <[email protected]> wrote: > > VFP's TXNLEVEL lets you know where you are in a (potentially nested) > > transaction level. Do other databases like MySQL/SQL > > Server/Oracle/PostgreSQL/Firebird have anything equivalent? > ---------------------------- > > SQL Server doesn't because you are within the transaction(s). There > is no showing of data back to the calling presenter mid stream. Where > in VFP you are just in a prg that has an option to rollback. > > Transactions are usually run from Stored Procs and being such they are > executed. You pass in params and you get a result back from the out > params. > > You can see something along the lines of this while in process: > > SELECT CASE transaction_isolation_level > WHEN 0 THEN 'Unspecified' > WHEN 1 THEN 'ReadUncomitted' > WHEN 2 THEN 'Readcomitted' > WHEN 3 THEN 'Repeatable' > WHEN 4 THEN 'Serializable' > WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL > FROM sys.dm_exec_sessions > where session_id = @@SPID > > You would read what level was in existance to determine if you could > continue. > 1. did an update. > 2. can I validate that it took sort of question/answer. > > -- > Stephen Russell > > Sr. Production Systems Programmer > CIMSgts > > 901.246-0159 cell > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
