>>I have a cust.dbf containing a memo field cust.details
>>
>>The following code has worked fine for years in VFP7
>>
>>
>>select * from cust where "price"$details
>>
>>
>>but it falls over in my new VFP9 upgrade - with "Memo file missing or Invalid"
>>
>>I.E. I can run the code against the SAME table on the same PC and it is fine in VFP7, not so in VFP9.
>>
>>I have tried converting the details field by using ALLTRIM(details) in the SQL command but this has made no difference - I get the same error.
>>
>>Anyone got any suggestions?
>>
>>Thanks
>>Barry Sutton
>
>VFP9 is more sensitive to the errors of the files.
>The file memo is not perfect.
Yes - I noted this from one of Sergey Berezniker's postings. I followed his advice which was to go to VFP7, copy the table to a temporary table, PACKed the table and then recreated the cdx indexes. This has sorted it out and it now runs fine in VFP9.