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

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.

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