Re: SQL_ERROR on SQLExecute() when using SQL_C_NUMERIC for parameters

On [Mon, 03.06.2013 20:33], Hiroshi Inoue wrote:
> Sorry for the late reply.
>
> (2013/05/26 19:38), Daniel Vogelbacher wrote:
> > Hi,
> >
> > when using SQLBindParameter with SQL_C_NUMERIC input, the function
> > returns SQL_SUCCESS. But a call to SQLExecute() returns SQL_ERROR with
> > "Syntax error on )".
> >
> > It seems that the psqlodbc driver did not replace the ? marker
> > properly and an invalid statement is passed to the server. This only
> > happens with SQL_C_NUMERIC, for other datatypes the marker gets
> > replaced.
>
> SQLSetDescField() causes the problem.
> SQLBindParameter() sets SQL_DESC_DATA_PTR field but subsequent
> SQLSetDescField() calls make the record unbound.

Ahh, many thanks for the hint.
Curious that the same code works fine with TDS and Firebird ODBC drivers :-)

> regards,
> Hiroshi Inoue
>
> > The used statement was:
> >
> > INSERT INTO numtest(num1) VALUES(?);
> >
> > where num1 is of type NUMERIC(5,3)
> >
> > The driver was built from source psqlodbc-09.01.0200.tar.gz for
> > unixODBC.
> >
> >
> > Here is the odbctrace for the specific part:
> >
> >
> > [ODBC][27210][1369515859.324218][SQLBindParameter.c][217]
> > Entry:
> > Statement = 0x1a908b0
> > Param Number = 1
> > Param Type = 1
> > C Type = 2 SQL_C_NUMERIC
> > SQL Type = 2 SQL_NUMERIC
> > Col Def = 5
> > Scale = 3
> > Rgb Value = 0x1a91210
> > Value Max = 0
> > StrLen Or Ind = 0x1a91230
> > [ODBC][27210][1369515859.324329][SQLBindParameter.c][397]
> > Exit:[SQL_SUCCESS]
> > [ODBC][27210][1369515859.324359][SQLSetDescFieldW.c][168]
> > Entry:
> > Descriptor = 0x1ab2ef0
> > Rec Number = 1
> > Field Ident = SQL_DESC_PRECISION
> > Value = 0x5
> > Buffer Length = -8
> > [ODBC][27210][1369515859.324402][SQLSetDescFieldW.c][246]
> > Exit:[SQL_SUCCESS]
> > [ODBC][27210][1369515859.324421][SQLSetDescFieldW.c][168]
> > Entry:
> > Descriptor = 0x1ab2ef0
> > Rec Number = 1
> > Field Ident = SQL_DESC_SCALE
> > Value = 0x3
> > Buffer Length = -8
> > [ODBC][27210][1369515859.324452][SQLSetDescFieldW.c][246]
> > Exit:[SQL_SUCCESS]
> > [ODBC][27210][1369515859.324480][SQLExecute.c][187]
> > Entry:
> > Statement = 0x1a908b0
> > [ODBC][27210][1369515859.328804][SQLExecute.c][348]
> > Exit:[SQL_ERROR]
> > DIAG [42601] FEHLER: Syntaxfehler bei <BB>)<AB>;
> > Error while executing the query
>
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>

--
Daniel Vogelbacher
www.chaospixel.com
cytrinox(at)freenode/ircnet/quakenet