>>>>Mark,
>>>>
>>>>SELECT gets its data from the disk file, the buffered change has not been posted to the disk file. The SELECT won't see the change until the buffer is tableupdated from the cursor.
>>>Yes, but isn't that SELECT uses an open alias?
>>>MArk
>>
>>SELECTS effectively do a USE AGAIN on your alias. It does not use your open alias, therefore it can not see the buffered records.
>So it goes to my hard dirve and open table again?
Yes, I guess that's what must happen. If it were to use your existing alias, image all the problems that would occur with the record pointer being moved all over the place during the select. Internally, SELECT does not use the alias you specify, it uses the it's own for the table. This is also why you can't use RECNO('alias'), etc. type statements for more than one table in a SELECT.