Not in VFP8. In any VFP version prior to VFP9, a query cannot see uncommited records. You'll have to use non-sql commands to access them. In VFP9 SELECT-SQL has a new clause
WITH (BUFFERING = .T.) that tells it to look into buffered data.
>Working with MySQL I have pulled down a data set, set the Tables, etc properties and set Buffering to 5.
>
>I then APPEND BLANK and replace a couple of fields.
>
>If I then do a
SELECT * FROM bufferedcursor
the newly appended records do not show up.
>
>Is there some setting which would make these records visible?
--sb--