For some reason the code within the SCAN is not working it only makes one pass. NO error message or anything. If I comment out the code and just have a wait window show the tmpzone, it passes through the entire cdsadd table. What could the problem be?

-----

SELECT cdsadd
SCAN
tmpzone = zone
TMPFILE = "zone" + alltrim(tmpzone) + ".dbf"
TMPFILE2 = "zone" + alltrim(tmpzone) + ".cdx"
WAIT window "file = " + tmpfile
IF FILE("&tmpfile")
WAIT window "file exist"
ELSE
WAIT window " file does not exist"
COPY TO "&tmpfile" FOR zone = tmpzone
ENDIF
ENDSCAN