I'm not sure this will solve the original problem of getting the .dbf data, but not memo fields. It's also dependent on what's been cleared from the write cache.
>Hi Brandon,
>
>Can you explain to me what below does? The RECCOUNT() picks the count up off the header of the file...what does GO RECNO() accomplish?
>
>Albert
>
>>Try this on applicable tables before your sql-select
>>
>>
>>** Eliminates cached data issues
>>TRY
>> SELECT (lcAlias)
>> =RECCOUNT()
>> IF !EOF()
>> GO RECNO() IN ALIAS()
>> ENDIF
>>CATCH
>> ** doesn't matter
>>ENDTRY
>>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer