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.ince@netzero.net> wrote in message
news:OLCX8.718$ak5.93@nwrddc01.gnilink.net...
> 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....
>
>
>