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:
00157392
Views:
26
>>>In VFP 5.0a this sequence of commands returns no records the returns records..What am I missing?
>>>
>>>select thisview && parameterized view w/several records (buffering =5)
>>>delete
>>>tableupdate(1,.f.,'thisview')
>>>requery('thisview')&& returns none
>>>requery('thisview') &&returns records
>>
>>Are you in the Command Window? You can get a false zero count there...
>
>Have done it both in form and command window..zero count is correct, browse show no records.
>
>'thisview' has reference to 4 different tables but only one is updateable.

I guess it depends on table relationships, what happens when you delete a record from multi-table view...but I don't know why successive requeries get different results at runtime, never've seen that...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform