>Is there a way more efficient than this (assuming no records are marked for deletion in normal use, and that if zero records, then there is not need for the TOUCH)?
>USE XXXX
>If RECC()>0
> GOTO 1
> DELETE
> RECALL
>ENDIF
>USE
>
>Thanks!
Not sure, but how about:
USE xxx
REPLACE Field1 WITH Field1
USE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.