>After packing some tables and the DBC, and making a minor change to a single table view, I am getting a lot of deleted blank records appearing on my "main table".
>
>This is not the table involved in the modified view.
>
>Occasionally this deleted blank record is where a "proper" record should be!
>
>The program hasn't changed for 5 months.
Well, *something* has changed - the challenge is to pinpoint it.
- Any hardware or electrical power issues? Anything in workstation or server event logs? Flaky network card or switch? Someone trip over a cable?
- Any change/updates to antivirus program(s)?
- Any relations or triggers set in your DBC? What version of VFP are you using?
- Does your app run on a framework that might be doing more than you think it's doing?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
