To be clear the following script will return the sum of 6 in both ASA 8.x
and SQL Anywhere 10.x:

create table t1
( row_id int default autoincrement primary key,
row_int int,
row_char char(30)
);

insert into t1(row_int) values (1);
insert into t1(row_int) values (NULL);
insert into t1(row_int) values (2);
insert into t1(row_int) values (3);
commit;

select sum(row_int) from t1;

As Chris has pointed out the only difference is that in version 10.x we
*properly* report the *warning* - a positive SQL Code value - that a NULL
value was eliminated or ignored in computing that sum. The recommended way
to handle this is to explicitly handle the *warning* in the application.
However, we know that some development tools do not allow the application to
handle the warning but arbitrarily treat it as an error. For those
development environments we have provided the option to "Suppress Fetch
Warnings" in the ODBC configuration. Note that this is *different* from the
"Delphi Applications" option.

Can you confirm that you have explicitly checked the "Suppress Fetch
Warnings" option and that you are still receiving the warning SQLCode = 109?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx...c?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Fantom" <szczukot (AT) poczta (DOT) onet.pl.skasujto> wrote