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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement