Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Barry Bell <Barry_Bell(at)harte-hanks(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date: 2012-04-12 13:24:09
Message-ID: 4F86D779.8050100@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Barry Bell 2012-04-12 17:12:19 Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Previous Message Ken Benson 2012-04-12 00:25:02 Re: UPDATE table via ODBC fails.