Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No records in Requery() after tableupdate
Message
From
14/11/1998 18:15:48
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
13/11/1998 10:53:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00157379
Message ID:
00157689
Views:
25
>>
>>SELECT Thisview && parameterized view w/several records (buffering =5)
>>DELETE
>>IF TableUpdate(1,.f.,'thisview')
>>   REQUERY('thisview')
>>ENDIF
>>*requery('thisview') &&returns records
>>
>>
>>This may be a timing problem in that the TableUpdate has not finished yet when the requery is issued. Using the IF will force VFP to wait for a return from TableUpdate before continuing on with the subsequent code.
>
>Nope, that wasn't the problem. This must have something to do with indexes or relationships that I am not seeing.

Just a WAG: try to do a Locate or Locate Rest after TableUpdate(). You're still sitting on a deleted record. Don't know why would that affect the requery(), but I've seen strange things happening while sitting in the air.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform