[DUG] ADO Issue

[Jeremy Coulter]

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" <Laurence at master.co.nz>
To: <delphi at ns3.123.co.nz>
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:  <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
>  
> 
>