[Firebird-odbc-devel] Problem with special transaction settings

[Marco H. <mh...@de...>]

Hello,

 

up to now we used the Gemini ODBC driver within our software successfully.
Due to it seems that this driver is not supported anymore we tested the
native ODBC driver with our software. We had some problems with a special
requirement:

 

It exists a situation to get a global lock to some tables. We do this by
using some special transaction settings. Here the statement:

 

#define LOCK_STMT (UCHAR*) "set transaction READ WRITE NO WAIT READ
COMMITTED RESERVING  ch_pos FOR PROTECTED WRITE, ch_pos_charge FOR PROTECTED
WRITE, ch_daten FOR PROTECTED WRITE, wb_prg_run FOR PROTECTED WRITE,
wb_schritt_run FOR PROTECTED WRITE, auftrags_daten_run FOR PROTECTED WRITE,
cmd FOR PROTECTED WRITE"

 

#define LOCK_STMT (UCHAR*) "set transaction READ WRITE NO WAIT READ
COMMITTED RESERVING " \

                                     " ch_pos FOR PROTECTED WRITE"
\

                                     ", ch_pos_charge FOR PROTECTED WRITE"

 

SQLExecDirect(hStmt, LOCK_STMT, SQL_NTS);

 

The execution of this statement is possible, but the following prepare of
any statement fails:

 

FEHLER: in SQLxxx call: E:\Tool Projects\odbc-test\test\dbcnv.cpp line 191:
sqlstate HY000; rsqlcode 4294966395; [ODBC Firebird Driver][Firebird]invalid
parameter in transaction parameter block 

table ch_pos is not defined

 

 

Is this transaction setting not supported?

 

Thanks in advance,

 

 

Marco Held

 



-- 
***********************************************************************
*    demig Prozessautomatisierung GmbH  *  demig Anlagentechnik GmbH  *
*                                       *                             *
* Anschrift:          Haardtstrasse 40  *  Haardtstrasse 40           *
*                       D-57076 Siegen  *  D-57076 Siegen             *
* Registergericht:     Siegen HRB 2819  *  Siegen HRB 5532            *
* Geschaeftsfuehrer:   Joachim Herbst,  *  Joachim Herbst,            *
*                        Winfried Held  *  Winfried Held              *
* Telefon:              +49 271 772020  *  +49 271 772020             *
* Telefax:              +49 271 74704   *  +49 271 74704              *
* E-Mail:                in...@de...  *  at...@de...                *
*                  http://www.demig.de  *  http://www.demig.de        *
***********************************************************************