I have a mysterious situation. I would like to know what is wrong with it. This happens occasionnaly. For some kind of reason, the following code, sometimes, will skip the SCAN loop even if _TALLY>0.

SELECT MySQL... INTO CURSOR TEMP
IF _TALLY=0
   RETURN
ENDIF
SCAN
   This is my scan loop...
ENDCAN
Rest of code here...

So, I always assumed that _TALLY>0, then the following code should not be executed. Well, sometimes, the SCAN is skipped completely. What can cause that?