[archive] How does MSSQL Transaction work with ACUSQL?

[Migrated content. Thread originally posted on 28 October 2010]

I have the code like



           EXEC SQL
             BEGIN TRANSACTION T1
           END-EXEC.
           EXEC SQL
             DELETE FROM csifsa23
             WHERE wpw_password = '5682'
           END-EXEC.
           EXEC SQL
             COMMIT TRANSACTION TI
           END-EXEC.



But when I run it, I got the error like



[ATTACH]459[/ATTACH]


I see simlilar question in forum:
http://www.acucorp.com/support/supported/customer_forum/showthread.php?t=1618&highlight=sql

It appears that your begin specifies T1 (tee one) whereas the commit specifies TI (tee eye)

[Migrated content. Thread originally posted on 28 October 2010]

I have the code like



           EXEC SQL
             BEGIN TRANSACTION T1
           END-EXEC.
           EXEC SQL
             DELETE FROM csifsa23
             WHERE wpw_password = '5682'
           END-EXEC.
           EXEC SQL
             COMMIT TRANSACTION TI
           END-EXEC.



But when I run it, I got the error like



[ATTACH]459[/ATTACH]


I see simlilar question in forum:
http://www.acucorp.com/support/supported/customer_forum/showthread.php?t=1618&highlight=sql

It appears that your begin specifies T1 (tee one) whereas the commit specifies TI (tee eye)

[Migrated content. Thread originally posted on 28 October 2010]

I have the code like



           EXEC SQL
             BEGIN TRANSACTION T1
           END-EXEC.
           EXEC SQL
             DELETE FROM csifsa23
             WHERE wpw_password = '5682'
           END-EXEC.
           EXEC SQL
             COMMIT TRANSACTION TI
           END-EXEC.



But when I run it, I got the error like



[ATTACH]459[/ATTACH]


I see simlilar question in forum:
http://www.acucorp.com/support/supported/customer_forum/showthread.php?t=1618&highlight=sql

It appears that your begin specifies T1 (tee one) whereas the commit specifies TI (tee eye)

Sorry, that's a typo. It should both be "T1"(tee one).


I am testing with acuSQL8.1.1 on MSSQL Transaction and I write the following codes:

EXEC SQL
BEGIN TRANSACTION T1
END-EXEC.
EXEC SQL
DELETE FROM csifsa23
WHERE wpw_password = '5682'
END-EXEC.
EXEC SQL
COMMIT TRANSACTION T1
END-EXEC.
I got error message as:

"Cannot issue SAVE TRANSACTION when there is no active transaction."

I tested the following codes in MSSQL Server:
BEGIN TRANSACTION T1
DELETE FROM csifsa23
WHERE wpw_password = '5682'
COMMIT TRANSACTION T1
It works.

In AcuSQL User's Guide Version 6.1, it provide
ASQL_TRANSACTION_METHOD configuration variable.But in
AcuSQL User's Guide Version 8.1.1 , it does NOT provide
this cinfigruation variable.

However,I tried to use configuration variable ASQL_TRANSACTION_METHOD in acuSQL8.1.1 in the "cblconfi" file as:
"ASQL_TRANSACTION_METHOD EXPLICIT"
It still gave me same error.

I could not see any sample programs provided with acuSQL 8.1.1 on MSSQL Transaction.

My question is
1.Could you explain how acuSQL works with MSSQL Transaction, does the example I provided have any problem?

2.Does acuSQL8.1.1 still support ASQL_TRANSACTION_METHOD configuration variabl?If so, how is it used? Could you provide an sample program?