>hi,
>
>thank you ,it works fantastic if mytable have a number exactly as 500000,
>
>but if mytable have 5000001,give error message(end of file encountered)
I see. Well, in that case, you must make the SKIP conditional:
use test
go top
i = 0
do while not eof()
copy to ("test" + trans(i)) next 100000
if not eof()
skip
endif
i = i + 1
enddo
The SKIP is required, because, for example, a "...next 10" will process records 1-10, but stay on record 10. So, the next command with "...next 10" will process records 10-19.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
