General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate not always working
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
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