I added the "SET INDEX" statement. It runs fine the first time. Now the second time through I'm getting the "File is in use error" again, this time it is occurring on the "SET INDEX" statement.
>After your 'Use pd_payments' statement, be sure you add the index statements
>
>if !used('pd_payments')
> use pd_payments
>endif
>select pd_payments
>SET INDEX TO PD_PAYMENTS
>SET ORDER TO 1
>
>Of course, you'll change the name of the index to the correct one.
>HTH
>Barbara
>
>>Thanks for the reply! I replace my USE statement with the code you indicated, but now I'm getting another error: "Table has no index order set" when the SET ORDER TO 1 command is run.
>>
>>>your select statement is using that table again.
>>>try
>>>
>>>if !used('pd_payments')
>>> use pd_payments
>>>endif
>>>select pd_payments
>>>...