>Hi all,
> I need to use an ALTER TABLE comand and shown below where the column is a variable that changes. I need to do this so that I can create the table that I want at runtime. Is this possible because foxpro uses the actual vaiable as the column name. Can anyone help?
>
>ALTER TABLE temp_call_details ADD COLUMN variable_name C( 1)
>
>I've also tried
>
>new_variable_name = &variable_name
>ALTER TABLE temp_call_details ADD COLUMN new_variable_name c( 1)

Use name expression. That is surround the varname with parentheses.

variable_name = "Newcolumn"
ALTER TABLE temp_call_details ADD COLUMN (variable_name) C( 1)

*ALTER TABLE temp_call_details ADD COLUMN &variable_name C( 1)
* Would also work but slower, name expression is the correct way

Cetin