The size of a field is too long.

From: "Krishna Gandhi" <Krishna(at)stimulussolutions(dot)com(dot)au>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: The size of a field is too long.
Date: 2002-04-02 22:57:47
Message-ID: D629160B44D8994399B7A9197F12481B0B525B@cascade.stimuluss.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I have found the one difference between the views that link and the ones
that generate the above error; they use the aggregate function SUM() on
a numeric field. After reviewing the FAQ (
http://odbc.postgresql.org/psqlodbc.php?DocID=faq-microsoft) I tried
casting these fields into the int4 type. This works and is fine for
fields that I don't require any decimals for, but what about those that
I do require decimals for?

Still searching for a workaround. Thankyou for your consideration.

Krishna.

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-04-04 03:45:50 Re: bpchar length problems
Previous Message Kristis Makris 2002-04-02 16:30:12 Re: 'infinity'::timestamp not translated correctly