In message <NBBBJKLIEJPCMJJOFDNPIEMOEIAA.alan@...>, Alan
McDonald <alan@...> writes

>oh dear, pete,
>if you have a query returning a million records, then I think you are in
>dire need of some design changes.
>You are using IBX, there is a Borland newsgroup for those components.
>borland.public.delphi.database.interbaseexpress

thanks, I will try there...

>You had better high tale it over to discuss those components.
>as for deleting, I think you are going about it the wrong way. Don't pull a
>million records over then decide how to delete some of them.
>Use a delete SQL query to do it on the server. IBX has components to do that
>too.

I don't think that I can delete in the way you suggest. I pull the
million over, then apply a complex set of rules, (a delphi component) to
decide if they require deletion. I can see no way of getting this to
work server side, the rules are just too complicated.

>If you were pulling an appropriate number of records over, then deleting the
>few that need deleting, client side, then you are probably not putting the
>delete statement into the component.

I can't!

>
>
>Alan

--
Pete Clark