Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 11 of 11 total
Thread Trying to create an index if it isn't in the table
Tue, Sep 17 2013 1:05 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PagePage 2 of 2
Jump to Page:  1 2
Image