This is a known issue with VFP cursors and SQL Statements.

You can get to the uncommited records if you use plain xBASE commands (SCAN, LOCATE, REPLACE), though.



>Hi,
>
>I've got a problem with uncommitted records in a view not showing up when a select sql statement is performed against the view.
>
>My view is a local, the same thing does happen on the remote version too, and is table buffered.
>
>The view itself works fine ,firing updates back to the base table as expected etc.
>
>if I add a record to the view, without issuing a tableupdate, and then perform a sql select statement on the view, any records that are uncommitted are not returned.
>
>The select statement looks like this ;
>
>select * from lv_myview into cursor mytempcursor
>
>If I issue a tableupdate after adding the record then the above statement returns the desired recordset.
>
>However, I cannot issue a tableupdate as they are other views on this form that need to be wrapped within a transaction, so I cannot simply tableupdate this one view here.
>
>One solution would be to create a cursor and the scan round the recordset contained within the view, addng each record contained in the view into the cursor. However, this seems a great deal of work and isn't as clean a solution as the sql select statement.
>
>Does anybody know any trick to get the sql select statement to work ok?
>
>Any advice greatly appreciated.
>
>Thanks, Mark