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 _______________________________________________ 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.
