Our applications are made with RDO to communicate with SQL Server. We just migrate from SQL 6.5 to 7.0 and we are still using RDO. After the migration, something strange is happening.

A query with a sum function return some value that comes from nowhere. If I replace the sum function by another aggregage function like avg it return the right informtation. The datatype of the field in the database is real.

Anybody has an idea???