Hi guys, I am running into some trouble with tableupdate and remote
views.

When I leave one screen, I am updating on the lostfocus event.

I am using remote views so I am using tableupdate and sqlcommit and
sqlrollback along with vfp transactions.

The problem I am running into is that it is not always updating
correctly.

Here is what is happening.

I select 8 records on the grid on the form. this causes them to
highlight based on the dynamic backcolor being setup to recognize the
change in the selected field of the route_status_vp view. I then
leave the form onto another form and in the lostfocus event want to
save the data back to the base ORACLE database. In a transaction I
issue tableupdate and sqlcommit on the connection handle.

For the 8 records the browse of route_status_vp is fine, and the
select * from route_status_vp is fine.

When selecting the first 2 records, everything is fine.

But when I select the first and third record, the local
route_status_vp is how I expected, but the select * from
route_status_vp shows the first and second record selected.

Any ideas?

Jason