>Gregory,
>
>yes your example is reight. I'm not sure about the speed thing, but thats only missing knowlegde. All I know is that the records will be listed in the order of index. I have no idea how this will effect the way they are retrieved and buffered - for long tables there might be a problem too. Lucky as I am I never had problems with such large tables.
>
>That's a kind of code obfuscation. If I mean FOR I do FOR.
>
>I would prefer a SELECT SQL -> SCAN anyway.
>
>I think the basic problem (Jerrys, not yours) here is the misunderstanding of the way the scope WHILE is working. Thats all what I like to point out.
>
>Agnes

Well, Agnes

Guess that you answered why while I answered how to make example 2 show the same output as example 1