>Hi Fabio
>
>Yep, using count to get around this, just wondered if they was a way around this using the SELECT command.
>
>Thanks anyway?
That's strange, really. VFP9 has a new clause to the SQL Select command, WITH BUFFERING = .T./.F., to give you more control. But the default behavior, which also applies to VFP8, is to always read from the disk, and NOT from the buffers, at least according to the documentatio. Have you tried to FLUSH before the Select comamnd?