Mark,
SQLSelect pulls from the "real" data (that actually on disk) - If it is only changed in the buffer, it is not on disk. If you need to access from the buffered table, use standard fox cursor stuff ie. count, sum, scan, etc. they will pull from the bufer.
Ken
>>Mark:
>> issue a =tableupdate(.t.) before you do the select then you will see the change.
>>sherry
><bg> What about with no tableupdate?
>Mark
Ken B. Matson
GCom2 Solutions