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 1 to 2 of 2 total
Problem with Reverse Engineered Index
Tue, Dec 4 2007 5:25 AM
Permanent Link
Peter Thorne
Sorry its me again.
Reverse engineering creates the following SQL chunk:
CREATE
INDEX "by_model_name" ON "Models"
("model_name" DESC COLLATE "ANSI")
DESCRIPTION 'Order by model name';
Looks like the DESC and COLLATE are the wrong way round so when I execute in an SQL window I get:
ElevateDB Error #700 An error was found in the statement at line 2 and column 20 (Expected ) but instead found COLLATE)
All operations done in 1.06
Peter
Tue, Dec 4 2007 4:33 PM
Permanent Link
Tim Young [Elevate Software]
Elevate Software, Inc.
timyoung@elevatesoft.com
Peter,
<< Reverse engineering creates the following SQL chunk: >>
Thanks, I'll make sure that this is fixed for the next release.
--
Tim Young
Elevate Software
www.elevatesoft.com