Sorry that was missleading....I should have been "Select SUM(BLAH) from MyTable"
I just did an example as apposed to a real SQL query that I am using because its ....easier....but the same result Jeremy -----Original Message----- From: "Laurence Bevan" <[EMAIL PROTECTED]> To: <[email protected]> Date: Tue, 15 Nov 2005 09:12:52 +1300 Subject: Re: [DUG] ADO Issue > 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
