Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Primary key with descending column
Wed, Dec 12 2007 6:40 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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
Image