Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |