>>
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only