I once had a corrupted DBF that was giving me a duplicate record on a simple SQL join. I tried reindex--DELETE TAG ALL--and still had the problem. Finally I performed a PACK on the table and all worked fine.
HTH,
--Paul
>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.
