Help needed with PGOleDB driver and ADO

From: "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Help needed with PGOleDB driver and ADO
Date: 2005-07-14 19:42:04
Message-ID: 000a01c588ac$1ed9f480$0200a8c0@amd2800
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

We have a numeric field in our table. When setting the value of this field to 10000.00, we experience the following problem when using ADO (with the PgOleDB driver) to query the table.

the field comes back correctly identified as a NUMERIC field, but the actual value of of the field is returned as 1

however, doing a select on the table yields the correct value for the field

if we make the value 10000.01 and then query in the application, it comes back correctly

Any help will be greatly appreciated

Thanks
Craig

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-07-14 19:45:31 Re: Standalone Parser for PL/pgSQL
Previous Message Tom Lane 2005-07-14 18:28:51 Re: Standalone Parser for PL/pgSQL