Re: ODBC Error while selecting a numeric data field

I have done a test and created the table with the field being a float
instead
of numeric and everything works fine.

Any help please???

"Tom Ince" <tom(dot)ince(at)netzero(dot)net> wrote in message
news:OLCX8(dot)718$ak5(dot)93(at)nwrddc01(dot)gnilink(dot)net(dot)(dot)(dot)
> I have tried PostgreSQL version 7.1.3 with iODBC-3.0.5
>
> and
>
> PostgreSQL version 7.2.1 with iODBC-3.0.6
>
> and in both cases I get an error when attempting to do a select on a field
> with the numeric data type.
>
> Using the psql program I do the following :
>
> CREATE TABLE test (lat numeric(9,6) );
> INSERT INTO test VALUES (12.23);
> SELECT * FROM test;
>
> When I do the select in the psql program I get :
>
> lat
> ----------
> 12.230000
> (1 row)
>
>
> Now, I have an application attempting to perform the same SELECT statement
> using the iODBC drivers SDK.
> When calling SQLFetch with a SELECT statement attempting to pull data from
a
> field of type NUMERIC, I get
> the error :
>
> 07006
> Received an unsupported type from Postgres.
>
>
> Please help....
>
>
>