Devart Forums

Hello,

Actually I´m having a problem with the DBExpress driver for MS SQL 2.50.4.0 ( I already try the newest version).

When I try to open a dataset that include a SUM statement, the corresponding field to the SUM column, reports an access violation error accesing the property "IsNull".

What is the problem ?? I'm using CBuilder 6.0 over Windows 2000

We couldn't reproduce the problem.
Please send us (dbxsda*crlab*com) a complete small sample to demonstrate it and include script to create and fill table.

As before, we couldn't reproduce the problem.
Please try to connect to this server from other PC.
Also find sqloledb.dll on your PC and send us its version, 2000.80.190.0 for example

I had the same problem in cascaded SQLQueries.
2 Sum fields always returned 0 as value.

It costs me hours.

I think dbx can't get the fieldtype of sum aggregate.

if your only working with ms sql server I have a simple sql workaround:


replace : select sum(a) as a from t
with : select convert(decimal(14,2), sum(a)) as a from t

regards