Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery Problem after tableupdate
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Requery Problem after tableupdate
Miscellaneous
Thread ID:
00357610
Message ID:
00357610
Views:
52
I have fields in pageframe (linked to lv_employee view) that I bring up on screen through requery (in init). The users change the record and I do tableupdate and requery (cmdsave). When I do requery after tableupdate, the values in the field being display are prior to user change. Tableupdate return a .t. and the table does get updated, but the value are old. If I exit form and come back in the new values are displayed. Here is following code:

*init
lc_eid = .d
requery('lv_employee') &&correct value displayed at startup
.refresh()

*cmdsave
&& user has changed values and is now being saved
r1 = cursorsetprop('sendupdates', .t.,'lv_employee') && r1=.t.
r3 = tableupdate(.t., .t., 'lv_employee') &&r3 return .t.
lc_eid = .d
requery('lv_employee')
.refresh() && old value still being display after requery

Does any know what the problem is ?????? help appeciated

thank you
Nick Patel
Next
Reply
Map
View

Click here to load this message in the networking platform