Postgres Pro
Downloads
Home   >   mailing lists

Re: Passing numeric Bind variables to ODBC driver convers to "Double precision" - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date
Msg-id 4F86D779.8050100@tpf.co.jp
Whole thread Raw
In response to Passing numeric Bind variables to ODBC driver convers to "Double precision"  (Barry Bell <Barry_Bell@harte-hanks.com>)
Responses Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"  (Barry Bell <Barry_Bell@harte-hanks.com>)
List pgsql-odbc
Tree view 
Hi Barry,

(2012/04/09 23:35), Barry Bell wrote:
>
>   Using the lastest of ODBC ANSI driver for windows 32bit ver 9.00.03  Calling from MS VFP 9.0
>
>   public nvar as interger
>   nvar=1
>   running the following sql:
>   "( select function_pkg(?nvar) "
>
>   The bind variable nvar will show in postgres as "Double Precision"  format instead of integer(or numeric)
>
>   Is there a setting on the ODBC driver for incoming vairables?

Are you turning on the Server side prepare option?

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Ken Benson
Date:
Subject: Re: UPDATE table via ODBC fails.
Next
From: Barry Bell
Date:
Subject: Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"