This problem has been addressed in VFP9 with WITH (BUFFERING = .T.) clause. In previous versions SELECT - SQL cannot see buffered data.

>
>Now i just make it simple. You try the code below and compare the result that i obtain.
>
>

>CREATE TABLE TEST(FLD_A cCHar(10),FLD_B nNUM(10,2))
>SELECT test
>APPEND BLANK
>REPLACE fld_a WITH 'AAA',fld_B WITH 10
>APPEND BLANK
>REPLACE fld_a WITH 'BBB',fld_B WITH 20
>BROWSE	&& SHow AAA, 10.  BBB,20
>SET MULTILOCKS ON
>CURSORSETPROP("Buffering",5)
>UPDATE test SET FLD_A ='CCC',FLD_B =30 WHERE FLD_A='AAA'
>BROWSE	&& SHOW CCC, 30. BBB, 20
>SELECT * FROM test	&& SHOW AAA 10, BBB20
>SELECT * FROM test WHERE FLD_A='AAA'	&& SHOW AAA 10
>SELECT * FROM test WHERE FLD_A='CCC'	&& SHOW NOTHING
>=TABLEUPDATE(.T.)
>SELECT * FROM TEST
>BROWSE	&& SHOW CCC, 30. BBB, 20
>

>
>That was my problem. Use select statement doesn't get CCC,30 before tableupdate(.T.).
>please try it out, Thank you!!