You beat me to it, Karen!
Albert
On 24/09/2012 2:40 PM, [email protected] wrote:
You can always just create the command as a whole string (can't verify
I got this right):
SET VAR vCommand = ('create index QueryTableIndex on' & .vQuery & '('
+ .vColumn + ' ASC)' )
&vCommand
Karen
In a message dated 9/24/2012 3:33:21 PM Central Daylight Time,
[email protected] writes:
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
