sorry - you can't convince me...
if you are having a problem deleting a record, I'm afraid I have to assume
there a a few other things you are currently doing based on innocent
ignorance of how it should be done for the sake of efficieny.

do you use a statement like
"delete from tablename where field=fieldvalue;"

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


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

>you need stored procedures
>i doubt it's too complicated for stored procedures

trust me, it is... there are a lot of conditions, and the Delphi
component written to check them is B I G.

The procedure is a 'file tidy' which deletes certain records under
certain, changing, conditions.

I don't have a problem with the time taken, it runs overnight, but I
still can't figure out how to delete single records from the file which
do not meet the criteria.

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