>There is no detail in the help about the '[WITH (BUFFERING = lExpr)]' clause
>in SQL.
>
>Anyone know more about this?

If you are opened the table in buffering mode (Table or Row) with this clause you can select uncommitedchanges in buffered table:

Try this:

CLOSE DATA ALL
CREATE DATABASE Test
OPEN DATABASE Test
SET DATABASE TO Test
CREATE TAble myTest (cTest C(10))
INSERT INTO myTest VALUES ("1")
INSERT INTO myTest VALUES ("2")
INSERT INTO myTest VALUES ("3")
INSERT INTO myTest VALUES ("4")
INSERT INTO myTest VALUES ("5")
USE
USE MyTest
SET MULTILOCKS ON
CURSORSETPROP("Buffering", 5,"MyTest")
GO 3
REPLACE cTest WITH [77]
SELECT * FROM MyTest INTO CURSOR woBuffering
SELECT * FROM MyTest WITH (BUFFERING = .t.) INTO CURSOR wBuffering

SELECT woBuffering
GO 3
BROWSE NORMAL


SELECT wBuffering
GO 3
BROWSE NORMAL