I need to create an index on the fly knowing only variables.
vQuery text='BillsTable'
vColumn text='PropIds'
Both values are an existing table and the column name is in that table.
This command does not work;
create index QueryTableIndex on &vQuery (&Column ASC)
nor this one;
create index QueryTableIndex on &vQuery (.vColumn ASC)
I keep getting this error message; "Error - Column vColumn is not in the table BillsTable"
This command has to be constructed with only variables.
Can anyone help make this command work ?
Thanks,
Bill Eyring

