>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?

I know several will respond that I dont need it, but I have a practice of doing a LOCATE before my scans. Just to ensure that I am at the top of the file. My 2 cents..