Try "select SUM(blah) as MySum from [My Table]" Laurence Bevan
----- Original Message ----- From: Jeremy Coulter To: <[email protected]> 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
_______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
