>Hi,
>
>Just wanted to confirm that I wasn't missing out on a known 'trick' in order to get round this 'issue'.
>
>Seems strange to me that you can reference the record using a scan but the select doesn't pick up the uncommitted records!
>
>Thanks, Hector,

The reason for this is that SQL selects open the target tables AGAIN i nnew workareas. This is so the record pointers, active indexes, etc. can be manipulated by VFP in order to opitmize the query and not have to worry about anything you have setup. Because it opens the tables/views again, it uses the disk presence of the tables to do this and not the memory resident version.