Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
Search Forums
»
Search Results
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 11 to 11 of 11 total
Trying to create an index if it isn't in the table
Tue, Sep 17 2013 1:05 PM
Permanent Link
Tim Young [Elevate Software]
Elevate Software, Inc.
timyoung@elevatesoft.com
Colin,
<< The error message says #401 The column TableName does not exist in the
temporary table Tables. >>
It's your initial catalog query:
if (Execute('Select * From Information.Tables '+
'Where Name='+Engine.QuotedSQLStr('Jobs') +
' and TableName = ' +
Engine.QuotedSQLStr('FeedbackDate'))=1)
should be:
if (Execute('Select * From Information.Indexes '+
'Where Name='+Engine.QuotedSQLStr('ZoneAreaOrder') +
' and TableName = ' + Engine.QuotedSQLStr('Jobs'))=1)
Tim Young
Elevate Software
www.elevatesoft.com
«
Previous Page
Page 2 of 2
Jump to Page:
1
2