ADOQuery problem when adding SQL Command

[tjessy]

hi,

i get an error message when i trying to add the SELECT line
with SUM(), or COUNT() to ADOQuery.SQL...

the code looks like this:

..
ADOQuery.SQL.CLEAR;
ADOQuery.SQL.Add('SELECT XY.XY, SUM(XY,XY)'); --> this causes an exception: Access violation in module msjet40.dll,

but if i remove SUM(XY,XY), it works fine.
(of course i've included GROUP BY at the end of the statement)

My question is, how can i use SUM(), or COUNT() with ADOQuery or ADOTable?

 

[coxpi]

Am not very sure but

You want to select range and then add

ADOQuery.SQL.Add('SELECT XY.XY, SUM(XY,XY)');

if so You must make sure that the values exists in the datasource,

If they are then I dont know what causes that