General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating Index String
I am trying to create a generic routine for creating index based on what I have stored in a table. The table contains the following fields - cexpression (the expression I want to index on), ctag (Name of the index tag I want to create) and cfilter (the filter). My problem is how to I write an expression so that when I say Index &expression it doesn't work. I know the syntax is INDEX ON eExpression TAG Tagname FOR expression. When I build the string how do I take out the 'ON ', 'TAG' and 'FILTER' so they are contained in the string. I hope I'm making since here.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only