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

Change the way the ODBC driver returns 'money'

From: "Mathew Frank" <mfrank(at)bigpond(dot)net(dot)au>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Change the way the ODBC driver returns 'money'
Date: 2001-08-07 10:19:06
Message-ID: HHEBIKEIGDLFABEKDCCKCEKMCGAA.mfrank@bigpond.net.au (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm using Crystal Reports (4.6) and any money types come out on the reports
as '0.00'.  This is due to the ODBC driver returning money types in the form
'$9.99' when Crystal is expecing a format of '9.99'.

When using MS-SQL ODBC there is an option to turn off 'localised settings'
(or similar) which you check off to get around this problem.

Is there a way I can do this with pg-ODBC?

Regards,
Mathew


pgsql-odbc by date

Next:From: Marc G. FournierDate: 2001-08-07 13:54:49
Subject: Re: To be 7.1.3 or not to be 7.1.3?
Previous:From: Justin CliftDate: 2001-08-07 04:03:44
Subject: To be 7.1.3 or not to be 7.1.3?

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