Skip site navigation (1) Skip section navigation (2)

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

From: Barry Bell <Barry_Bell(at)harte-hanks(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date: 2012-04-09 14:35:10
Message-ID: 542B943ED5D72E408BF9CBBD61ABC94D52D10C5C@VA3DIAXVSC31.RED001.local (view raw or flat)
Thread:
Lists: pgsql-odbc
 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?

Responses

pgsql-odbc by date

Next:From: Alexandre - Aldeia DigitalDate: 2012-04-09 23:25:53
Subject: Re: Problem with Use Declare/Fetch
Previous:From: Jack WilsonDate: 2012-04-08 19:44:54
Subject: Re: Very basic question from a beginner

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group