>Jess,
>
>I had something like this once. We decided the record was somehow corrupt - either weird characters in it somewhere, or a bad spot on disk. Easier to just re-create the record as you did.
>
>
>>We have an Item Master File that contains approximately 30,000 records. In a rare situation, there is an specific item record that if selected as included in the Invoice_Line_Item details, the entire app crashes. What we do is that we delete the item in the Item Master File and then create another one to make it work. Is this an Index problem? Anyone encounters the same?
Cindy,
So, it seems to me that VFP file tables are really hard to maintain. We keep on reindexing files at least 3 times a month. The system that I am currently handling is a hospital system which has volumenous records at least 4,000 invoices a day. Our client is getting angry why they need to do such thing? Is SQL Server a silver bullet solution for this?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."