General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Requery Problem after tableupdate
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
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