Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No records in Requery() after tableupdate
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00157379
Message ID:
00157793
Views:
25
Bruce;

Here's the test code w/results:

SELECT vshipdet
requery('vshipdet')
viewcount = _tally && viewcount = 4
DELETE
if tableupdate(1,.f.,'vshipdet')
requery('vshipdet')
viewcount = _tally && viewcount = 0
else
wait window 'vshipdet screwed'
return
endif

**** this requery seems to be necessary for some unknown reason
requery('vshipdet')
viewcount = _tally && viewcount = 3

As I said, same result in 5.0a or 6, same result in command window or form and it only shows up when the view has more than one table.

Could you see if you could recreate using a local view with more than one table?
If you can't, i have to assume its the view.......
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform