From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain |
Date: | 2009-03-09 16:15:07 |
Message-ID: | 1236615307.4649.0.camel@jd-laptop.pragmaticzealot.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On Mon, 2009-03-09 at 15:07 +0000, Peter Geoghegan wrote:
> Hello,
>
> I'm attempting to get Crystal reports working with PostgreSQL with an
> ODBC connection, via psqlODBC. I can successfully establish the
> connection easily. However, I have a domain called "currency", that
> handles currency values:
>
> CREATE DOMAIN currency
> AS numeric(10,2);
> ALTER DOMAIN currency OWNER TO manager;
>
> fields of currency appear as "strings" in Crystal reports, and they
> lack fixed precision ( the value 1.00 appears as 1, for example). Why
> might this be? How can I get it to appear as a numeric type, which I
> can find the sum of, etc?
Just use numeric and don't create a domain?
Joshua D. Drake
>
> Thanks,
> Peter Geoghegan
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2009-03-10 09:50:53 | Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain |
Previous Message | Jan-Peter.Seifert | 2009-03-09 16:06:27 | Re: Driver crashing on many temporary tables? |