Add 100 fields to an existing table 2

[RussA]

I would like to add 100 fields to an existing table, what do I need to change to make this work? Thanks in advance Russ.

For x = 1 to 100
field_name = "col" + str(x)
Alter TABLE table_name ADD COLUMN field_name n(10,2) NULL
Next x

 

[rgbean]

Russ,
Close - just change the one line to:

Alter TABLE table_name ADD COLUMN [b][red]&[/red][/b]field_name n(10,2) NULL

Rick

 

[DSummZZZ]

You may also need to change this line:
field_name = "col" + str(x)
-to-
field_name = "col" + ALLTRIM(str(x))


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[GriffMG]

The code is good, but would be VERY inefficient if the existing table is large.

If it is, I would suggest that you create a new table with the desired structure and append the data to it.

Or copy the contents to a temp table, zap the existing one then pull the data back.


HTH

Regards

Griff
Keep [Smile]ing

 

[rgbean]

Griff,
So practical! I figured this was a one shot situation and simplicity was the key.

Rick

 

[GriffMG]

Sorry, Rick - I'm too geeky for my own good!

Regards

Griff
Keep [Smile]ing