>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.