APPEND FROM Not Working

[davewelsh]

I have some code that gets information from users and puts it in a temporary table. After all the information is entered, the data is put into the permanent table (same structure) via an APPEND FROM statement.

Once or twice a month, the APPEND FROM ... statement doesn't do anything. The rest of the program works fine and so does the rest of the application. It seems like that line has effectively been removed.

This problem keeps happening -- even if the application is shut down and restarted. The only way to make that statement work again is to reboot the computer.

Because of this I think that it is not a problem in the code or the data being entered, but something with VFP itself.

 

[DSummZZZ]

Does the statement only say APPEND FROM filename or is their some other criteria involved, like a date range? If so, maybe the records are getting filtered improperly.
Maybe drive mappings are getting lost or removed, or maybe the temp file is located somewhere unexpected. Maybe it would help if you sent a code sample.

Dave S.