http://dbcusers.com DB/C and PL/B language download,reference and resource site en Mon, 06 Sep 2010 00:46:41 GMT vBulletin 60 http://www.dbcusers.com/images/misc/rss.jpg http://dbcusers.com http://dbcusers.com/showthread.php?t=154&goto=newpost Tue, 24 Aug 2010 09:47:18 GMT Hi,

I'm trying to use SELECT SUM(X) FROM Table, but I don't get the expected result on the query as the sum is truncated to hold as many digits as X is specified in the table design. If X is declared FORM 1 in DB/C I will get an incorrect answer as soon as the total is greater than 9.

I'm running DB/C 14.0 in UNIX and FS 4.0. The query is tested both in EXCEL VBA and in .NET that use FS 4.0 ODBC driver.

Any ideas why the result is truncated ?

Also using CAST within a SUM does not work as expected. Is that not possible
or is there some hidden language to use ?

Best regards
Lars Westerlund ]]> Open DB/C discussion Lars Westerlund http://dbcusers.com/showthread.php?t=154