>>
>>Dear Barbara:
>>Here is the code which runs off the click event of a command
>>button. If you sort it first and * out the sort command
>>everything runs fine. But if you include it you get a
>>file use use error which I believe means the program proceeds
>>without letting the sort finish. I'm grateful for any help,
>>Derek.
>>
>>use c:\suspense\Invrprt\Invtotalp.dbf
>>delete all
>>pack
>>Sort to c:\suspense\stock1.dbf on Number
>
>Derek,
>I think you will find that the error is caused by sorting an empty database - your previous two lines said "delete all" and "pack" - this emptied the database. This error comes up in a number of other situations when the file is not in use. Try copy structure to c:\suspense\stock1 instead. Another point - you did not specify to use invtotalp EXCLUSIVE - packing this file may cause an error - I prefer to specify shared or exclusive every file I open and have exclusive off - this is just my preference of course. Regards,

Dear Barbara & Nigel,

My humble apologies, while I was away at lunch I reallized
that in adding back the sort line I forgot to add back the
line before it which was simply "use c:\suspense\stock1.dbf".
I am sorting the file to itself which works other places.I hope
I didn't inconvience you too much with this dopy mistake.
Sorry Derek.