"Sekcja Informatyki Medycznej" <informatyka@cskmswia.pl> writes:
> I have encountered a problem with following query run over ODBC in MS VS 6.0
> SP5 in DataEnvironment designer:
> "SELECT SUM(field1) FROM table1;"
> field 1 is of type INT4.
> There is "E_FAIL" error message.
SUM() of int4 yields type NUMERIC these days. Perhaps MS VS doesn't
know what that is, or perhaps our ODBC driver doesn't handle it well.
A possible workaround is to cast the result back to int4, but that
just re-exposes you to the overflow risk we were trying to eliminate...
regards, tom lane