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