PostgreSQL ODBC connection from Crystal reports in windows, currency domain

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема PostgreSQL ODBC connection from Crystal reports in windows, currency domain
Дата
Msg-id db471ace0903090807y182480a9rbb2de5b8376f314@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-odbc
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?

Thanks,
Peter Geoghegan

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Jan-Peter.Seifert@gmx.de
Дата:
Сообщение: Re: Driver crashing on many temporary tables?
Следующее
От: Jan-Peter.Seifert@gmx.de
Дата:
Сообщение: Re: Driver crashing on many temporary tables?