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