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

Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain

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 (view raw or flat)
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


In response to

Responses

pgsql-odbc by date

Next:From: Peter GeogheganDate: 2009-03-10 09:50:53
Subject: Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain
Previous:From: Jan-Peter.SeifertDate: 2009-03-09 16:06:27
Subject: Re: Driver crashing on many temporary tables?

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