you need stored procedures
i doubt it's too complicated for stored procedures
-----Original Message-----
From: Pete Clark [mailto:lnnp@...]
Sent: Monday, 4 November 2002 10:28
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Delphi Delete Records


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

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]