>is there a way to run a select sql over a buffered table and get also updated records ?
> thank you all
>Alessio

Alessio,
'updated records' ? Updated ones are already in SQL result, I think you meant those not updated yet.
With VFP7 and using SQL it's not possible (VFP9 has with buffering). However under VFP7 there is a simple workaround - copy to.

select bufferedTable
m.lcTemp = sys(2015)
copy to (m.lcTemp) && if small to array is a choice
* SQL here - nofilter
erase (m.lcTemp+'.*')

Cetin