[RBASE-L] - Re: Create Index Command using only variables

[Bill Eyring]

Karen and Al,
 
Thanks for the help. Karen you hit on the solution. Also I found a needed
variable was not in the original button code.
 
Many thanks !
 
Bill Eyring

  _____  

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of
karentel...@cs.com
Sent: Monday, September 24, 2012 4:41 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Create Index Command using only variables


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,
beyr...@lampsoftware.com 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