#1 will allow you to change the caption.
#2 would be easier if you just called MyQuery.ExecuteImmediate( 'delete from
...', nil );
That way it will take less chatter on the network, execute more quickly and
not require an object be dynamically created.

FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Andreas Pohl" <apohl@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, September 20, 2001 8:46 AM
Subject: Re: [IBO] Enhancement Request


> #1: What about TIB_Query.CallbackCaption ?
>
> #2: subclass TIB_Query and provide a function using a dsql call like:
>
> query:=sender as TIB_Query;
> with TIB_DSQL.Create(nil) do begin
> ib_connection:=query.ib_connection;
> ib_transaction:=query.ib_transaction;
> sql.text:=format(' delete %s ' ,[query.sqlfrom.text]);
> prepare;
> execute;
> query.ib_transaction.commitretaining;
> end;
>
> This is written right from my mind, please check syntax again :)
>
> Mit freundlichem Gruss & Best Regards
>
> Andreas Pohl
> apohl@...
> www.ibp-consult.com
> ----- Original Message -----
> From: "Johan Kotze" <jkkotze@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, September 20, 2001 4:36 PM
> Subject: [IBO] Enhancement Request
>
>
> > Hi Jason
> >
> > There are 2 thing I would like to see in IBO.
> >
> > 1. On the messagebox that displays the "Fetching xxxx rows" message,
> > could you include the component(IB_Query, etc) name or caption? It
> > would help me determine where my code causes large amounts of data to
> > be retrieved.
> >
> > 2. I would like a EmptyTable funtion and a EmptyTableSQL property
> > added to IB_Query that will execute the SQL statement specified in
> > EmptyTableSQL. It must also commit the changes and drop all local
> > cached data from the query.
> >
> > If you have time ;-) and feel like it, it would be much appreciated.
> >
> > Regards
> >
> > Johan Kotze