IBM Informix OLEDB driver bug

Posted in 2003

Thomas — 15 Jul 2003 09:56:25 -0700 — source: Usenet: comp.databases.informix

My code sum a database column whose type is 4 bytes integer Select SUM(col1)

↪ replying to Thomas

Fernando Nunes — Wed, 16 Jul 2003 01:14:59 +0100 — source: Usenet: comp.databases.informix

Thomas wrote: > My code sum a database column whose type is 4 bytes integer > Select SUM(col1) > From tbl > GROUP BY col2 > ORDER BY col3 > > The SUM value can be up to 7 digits. I have it output to a webpage. > When I looked at the result, I found the sort doesn't work, a small > number is in between two larger ones. I tried a work around by > changing my code to > SELECT SUM(col)*1. Magically I see the right result on my webpage. > > I use ADO, OLE drivre is from IBM Informix Connect ver2.81. Informix > server is IDS9.4 on Solaris. > > I also tried to use ASP.NET. Howerve this clause will break with the > walk around. > dataAdapter.Fill(dataset, "tbl"). At the end of it long stack list, > the error is a paramter is missing in a function. Obviously has > nothing to do with my code. However, with the previous code everything > is fine, except the previous bug appears again:( > > Thanks for any advice, And the table schema is...?