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
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.
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.


Alan
-----Original Message-----
From: Pete Clark [mailto:lnnp@...]
Sent: Monday, 4 November 2002 9:30
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Delphi Delete Records


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

>what connection components are you using?
>ibobjects has their own list
>IBX has the Borland newsgroup listing
>so too does dbExpress

TIBDatabase, etc., in Delphi 6.

>
>deleting can be done in many ways depending on what you really want to

do.

I haven't successfully found any!

I run thru a "while not eof" using a IBQuery. I then run a complicated
Delphi function over the current record, and under certain
circumstances, delete the record. Simple.

But I can't figure out an elegant (read "working") method to delete the
record. The main query returns a million plus records.

>
>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]