Re: EDBClient Errors??

From: ATM Dude (news_at_phreakshow.no)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 11:38:59 -0800

    Solution:

    After rearranging the whole way I was working with the tables and
datasets to try and simplify so I can narrow it down better, it was
still doing this.

    Closer examination of my ClientDataSets revealed an
"AggregatesActive = TRUE" in the properties, a remainder from
experimenting with aggregates. There were two aggregates listed, but I
don't know if they were constructed properly.

    Changing the AggregatesActive to FALSE stopped the EDBClient Errors
completely.

    I don't know why.

Thanks for your reply, though.

ATM Dude wrote:

>
> I came to Delphi 6 pro from Turbo Pascal and am learning alot about
> datasets and datasources and SQL, so I'm probably doing something wrong.
>
> What is an EDBClient error? If I run my application without summoning
> the reporting form, I can exit and nothing happens, but if I run a
> report, and exit, I get "Exception: EDBClient in module
> myapplication.exe at 000C9B89. Invalid parameter."
>
> There are two datasets/sources as well as three SQL tables that are
> only used on that form, I open the tables OnShow and close them
> OnHide, the datasets are just active all the time.
>
> It works, but confuses my boss when the message comes up.
>
> Thanks for any help.
>

Relevant Pages

  • Re: Why is "group by" obligatory in SQL?
    ... Probably because they believed in the myth of natural programming ... SQL is no exception. ... we slowly shifted from a declarative oriented language to a verbose ... variables seprating the aggregates from the operation such as ...
    (comp.databases.theory)
  • Re: Moving a VBA function to SQL server
    ... SQL is a set-based language. ... and format the jobheader in your VBA code. ... find this particularly so when doing aggregates of aggregates ... ...
    (comp.databases.ms-access)
  • Re: whats the advantage of ORM?
    ... What happens when you need to make some really complex queries, ... joins of different types, group by's and aggregates? ... DBI you had to have a good knowledge of SQL and the sql ... i am using SQL lite for the database at this stage as I am playing ...
    (perl.beginners)
  • Re: Getting a total control to find totals for last 7 days via a q
    ... Going back to your SQL though, the funny thing is, your SQL is exactly what ... Anyway, I now have your clear instructions, which is 4 seperate queries, ... calculating aggregates of aggregates is tricky. ... CountAS AllAnswers, ...
    (microsoft.public.access.queries)