Load 1 to 100 without Recno() or Autogenrate

[#1]

Hi,

Is this possible to load 1 t0 100 without Recno() or Autogenerate

I know we can do with...    Load RecNo( ) as A autogenerate(100);

but

someting Like

i=1;
for i= 1 to 100;
load i as ID;
next i

[peschu123]

Can you use:

FIRST(100) LOAD

..

..

..

FROM ... ;

Regards Peter

[rustyfishbones]

do you mean like

FIRST 100, will only load the first 100 rows from the source data

LIKE THIS

[rwunderlich · Accepted solution]

You can do it just as you described, but you sill need a data source -- which can be the AUTOGENERATE keyword.

i=1;

for i= 1 to 100;

load $(i) as ID autogenerate 1;

next i

-Rob

[#5]

So still we need to use autogenrate!

I am thinking some thing similar in VB.

Thanks Rob,

Vinay