Try this
SET VAR vQuery text = 'BillsTable'
SET VAR vColumn text = 'PropIds'
SET VAR vCommand = ('CREATE INDEX QueryTableIndex on' & .vQuery &
'(.vColumn ASC)')
&vCommand
Albert
On 24/09/2012 2:31 PM, [email protected] wrote:
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
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2013.0.2677 / Virus Database: 2591/5785 - Release Date: 09/22/12
