Re: Aggregate Functions

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 05/08/04


Date: Fri, 07 May 2004 21:03:34 -0500


>Note that this error only occurs when I am using Delphi to step thru the
>program. I have kept the code simple:
>
>With DM.ADOQuery3 do

I see that Vitals suggestion worked for you.
My advice is use a TadoDataset instead of a TadoQuery.
TadoQuery was intended only for a quick conversion from Tquery and there is
unnecessary overhead in adding Strings to the SQL statement.

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com


Relevant Pages

  • Re: DefaultExpression broken
    ... It is not implemented for TADOdataset or TadoQuery ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: "Parameter Information cannot be derived from SQL..." Error
    ... your query if you are using TadoDataset or TadoQuery ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery or ADOTable?
    ... TADOQuery is ok for querys, but as TADODataset has all the ... > features, ... As per Delphi Help. ... TADODataSet is not capable of issuing Data Manipulation Language SQL ...
    (borland.public.delphi.database.ado)
  • Re: slow refresh of mysql datasets via ADO
    ... the nasty habit to try to load the whole table data. ... TADODataset instead. ... I already got rid of the table. ...
    (borland.public.delphi.database.ado)
  • Re: Changing DB with TADOConnection
    ... >to the new DB and can even oepn up a TADOQuery and manipulate it. ... >However, when I then go to open a TADODataset, I get either a "stack ...
    (borland.public.delphi.database.ado)