how to insert many rows into a test table?

[wchuacs]

Hi,

how to we insert say 500 or 1000 rows of records in a test table for some scenarios testing ?

pls advice, and thank you.

 

[repete]

hi wchuacs
the following syntax applies to visual foxpro, may help you in your situation

create table test01 (field01 c(5), field02 n(3))

for i = 1 to 500
value01 = alltrim(str(i))
value02 = i
insert into test01 (field01, field02) values (value01, value02)
endfor[\code]


Pete Bloomfield
Down Under