[DUG] ADO Issue

[Laurence Bevan]

Try "select SUM(blah) as MySum from [My Table]"

Laurence Bevan


----- Original Message -----
From: Jeremy Coulter
To:  <delphi at delphi.org.nz>
Cc:  
Sent: Tue, 15 Nov 2005 08:29:23 +1300
Subject: [DUG] ADO Issue

Hi All.
I have come across an issue in D7 where if I do the following query using
the ADO Controls when querying an Access DB, I get an error raised (at
designtime) saying an exception has occured in msjet40.dll. If I press the
OK button, every thing still works ok, and I get the results from the query.
 
"Select SUM(blah) From My Table"
 
Its the SUM is doesnt seem to like or rather throws the error. COUNT etc.
are fine, and it IS a number field, not a string or text field.
 
The weired thing is, it only happens at run time, and doesnt affect the
exe.....that was...until I started using an app. that uses threads, and now,
it hangs the application !
 
Anyone know why the above error occurs? Do I just need to change a property
to solve it etc?
 
Thanks, Jeremy

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.0/167 - Release Date: 11/11/2005