I didn't know that. Thanks


>DELETE FOR locks a table header for duration of the command. If somebody else has the header locked already for INSERT INTO, DELETE FOR, UPDATE FOR, e.t.c., than the error will be generated. To avoid the header lock you can use

>  SELECT TempItems
>  SCAN FOR ProcBatch = .sProcBatchId
>    DELETE
>  ENDSCAN
>* OR
>  DELETE FROM TempItems WHERE ProcBatch = .sProcBatchId
>
>

>>User's a randmonly reporting a 'File is in use by another user' error
>>on the TempItems line. I have no idea why.
>>
>>

>>PROTECTED PROCEDURE _DeleteTempRecs() AS VOID
>>	
>>  WITH This
>>
>>  SELECT TempHead
>>  DELETE FOR ProcBatch = .sProcBatchId
>>			
>>  SELECT TempItems
>>  DELETE FOR ProcBatch = .sProcBatchId
>>
>>  SELECT TempDet
>>  DELETE FOR ProcBatch = .sProcBatchId
>>		
>>    ENDWITH
>>	
>>ENDPROC
>>