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