>That doesn't seem to work. This process is run at night, and the table is still locked. However, when I come in and rerun it in the morning, it isn't locked afterwards. Here is my code:
>
>
>*Clear DEAL table
>Use "F:\DATA\DEAL.DBF" In 0 Exclusive
>SELECT DEAL
>ZAP
>
>APPEND FROM (lcFileName) SDF
>
>SELECT DEAL
>USE IN DEAL
>
That should work.
whats SAFETY set to ?
Sure there isn't a prompt sitting on screen about wether its ok to zap the file at night?
Nick