Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Primary key with descending column |
Wed, Dec 12 2007 6:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | How can I do this? eg from DBISAM
PRIMARY KEY ("_fkProjects","_Date" DESC) COMPRESS NONE What's the ElevateDB equivalent? Roy Lambert |
Wed, Dec 12 2007 2:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< How can I do this? eg from DBISAM PRIMARY KEY ("_fkProjects","_Date" DESC) COMPRESS NONE What's the ElevateDB equivalent? >> There isn't one. You'll have to define another index with the descending columns. Primary keys are constraints in EDB and SQL2003, and therefore don't actually have the concept of descending columns. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Dec 13 2007 3:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>There isn't one. You'll have to define another index with the descending >columns. Primary keys are constraints in EDB and SQL2003, and therefore >don't actually have the concept of descending columns. Arghhhhhhhhhhhhhhhhhhhh |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |