Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |