General information
Title:
Corrupted record in table
Here is my problem. Please, sit down and read carefully (it is very messy!).
- I use VFP 5.0a French.
- I have a table with 700 records that represent differents products.
- An input form has a textbox to get the product number and a combobox with the product description.
- The textbox and the combobox both have the same RecordSource.
- It worked great until a corrupted record appeared. Even then, only the corrupted record did not work. All other recors worked well.
- When a corrupted record is used, a message like « ALIAS '' NOT FOUND » OR « IS NOT AN OBJECT » or even a «PAGE FAULT» is given on the READ EVENT. The message may be different.
- I tried to repair it by going on the record, SCATTER MEMVAR MEMO to get information in memory, changing the product number (primary key), adding a new record, GATHER MEMVAR MEMO to get back the information from memory.
- When I do that, the new record works well until I delete the renamed record (The old one).
- I looked at the table in Hexadecimal to see if there was differences between the good and the bad record: I did not found anything (let be franc: I am not an expert in hexadecimal!).
- I tried to reconstruct my table by creating the structure from scratch and then to APPEND FROM the old table, to execute an SQL query and to direct the result in a new table, and many more, but the corrupted record always followed.
- I then realized that if I set the DELETED OFF, the corrupted record works well. The problem is that the entire system is developped to function with DELETED ON.
- I arrive to the following conclusion:
1) I have more corrupted record than I tought;
2) For a record to work, some other record MUST be there and some other MUST NOT be there;
3) It looks like I will not be able to repair this problem without recreating the entire table by hand. Even then, I have no garanties that the problem will not return.
Can you help??? It would be greately appreciated! I am working to find a way to publish an exemple. It might help to resolve this weird problem.
Next
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