If I have a transaction, the transaction is declared
in my VB program with the connection object conABC, as conABC.BeginTrans
and in that transaction I insert into a temp table, ##meetings and then
later on do a rollback (from the vb program), conABC.RollbackTrans
does the temp table, ##meetings get rollbacked to?
Thanks in Advance,
Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing Education
Re: Regarding EVALUATE TRUE ... with multiple 88-levels, and a numeric TEMP.... for the WHEN's and their imperatives.... WHEN NO-OUTPUT-TRAN... continue with output transaction processing... ... (comp.lang.cobol)
Re: Transaction isolation levels ... SELECT 'X' INTO #TEMP... locks the row in table TICKETS until the entire transaction has ... The lock taken out on TICKETS will be a shared lock ... that under the default isolation level will be released. ... (comp.databases.ms-sqlserver)
Regarding EVALUATE TRUE ... Usually I follow the Doc's prescription for whatever ails me in COBOL, ... with multiple 88-levels, and a numeric TEMP.... for the WHEN's and their imperatives.... continue with output transaction processing... ... (comp.lang.cobol)
Re: Problem trying insert data into a temp table via SP ... needs to load some data into a temp table. ... But throws another exception, -535 (Already in transaction), this ... fact that DB-Access is a separate session will kill you again - ... (comp.databases.informix)