Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
An updatable RV that doesn't update
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
An updatable RV that doesn't update
Miscellaneous
Thread ID:
00894973
Message ID:
00894973
Views:
51
this is pretty wierd for me, I don't have any explanation, maybe you guys do.

I have a form which utilizes 3 updatable Remote views. one of them fills a grid, when the user navigates through the records a method is called where the grid's view is requery and presents the data related to the value in the main table.

after the user moves the data in the grid is updated runing a
TABLEUPDATE(.T.,.T.,"GRID_TABLE")
Then another method is called which performs the requery. now, every thing goes well if when modifying the values in the grid, I hit enter and skip to the other column or change the record on the grid before skiping to the next record in the main table.

but if I modify the field in the grid and don't chnage the control or don't move the pointer to other row in the grid. then I got a error message in the requery() telling me that there are uncommited changes in the grid's table even though the tableupdate performed with out problems.

I have the rowbuffering set to 5

VFP7 SP1

any ideas?
.......
DO WHILE .T.
      ME.Work()
ENDDO
Next
Reply
Map
View

Click here to load this message in the networking platform