General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Mark,
I found the same thing. I finally create a cursor and, using SCAN...ENDSCAN, copied the records to the view. You can then run your SQL.
HTH
Rex
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only