>>>is there a way to run a select sql over a buffered table and get also updated records ?
>>> thank you all
>>>Alessio
>>
>>No in that version of VFP you use. In VFP 9 there is a WITH BUFFERING = .t. to retrive buffered records.
>
>Do you think it's better to update the application to the new version or
>complete manually (I was thinking about a loop which considers the GetNextModified ) the query result ?

Ciao,
anche in VFP9 non puoi usare una query per trovare i records modificati,
perchè nelle SQL Select non sono supportare le funZioni GETFLDSTATE(),OLDVAL()....,
e quindi la query ti restituisce le righe senza distinzione tra buffer e non buffer

Hello,
also in VFP9 you cannot use a query in order to find the records modified, why in the SQL Select they are not to support functions GETFLDSTATE(), OLDVAL()....;
and therefore the query it gives back the lines to you without
distinction between buffer and not buffer