Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious REQUERY() Bug Update LP
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00816081
Message ID:
00816254
Views:
23
Accidently hit enter before I completed my stub funtion but you can see where I was headed. The key is the function would have to not only introduce the wait state, but also clear the current alias by closing it and then reopening with NODATA because my experience has been that when requery does fail, the previous results stay in the query and that could cause other problems in code. Something like:

FUNCTION vRequery
PARAMETERS lcAlias
LOCAL lnResult
lnResult=REQUERY(lcAlias)
IF lnResult < 1
SELECT (lcAlias)
USE ( lcAlias ) NODATA
ENDIF
RETURN lnResult

Of course this is just an example, there would be much more required and I am not sure it makes since to proceed with VFP8 as there are likely more issues here than just REQUERY(). I suspect in light of the example I gave that memory corruption or some other internal VFP structure is getting messed up, and who knows what other problems could come up in a production application.

Thanks
Bob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform