Creating table name with Variable

[zagzebski]

Basicallty I want to loop through this table giving it a new name by combining "Prod" and the value of i.  So it would be Prod1, Prod2, Prod 3, Prod4 and Prod5.  How can I add the value of i to "Prod" so I get five sepearate tables?

For i = 1 to 5

Prod:

Select *

Resident PreProd;

Next i

Thanks in advance

Steve

[#2 · Accepted solution]

Just use your counter in the tablename, you will need to use noconcatenate to keep them separate though otherwise as the fields are the same the tables will auto concatenate

For i = 1 to 5

Prod$(i):

Noconcatenate

Load *

Resident PreProd;

Next i

hope that helps

Joe

[marinasbc]

Hi,

For i = 1 to 5

Prod$(i):

Select *

Resident PreProd;

Next i

Regards,

Marina

[Anonymous]

try this...

qualify *;

for i = 1 to 5

Prod$(i):

load *

resident PreProd;

next i

[zagzebski]

Thanks!