Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Sat, Feb 4 2006 1:03 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim I've just tried setting a master-detail relationship using a compound index with a descending part of the index and the IDE chokes on it telling me there isn't an index for the field Index is integer ; timestamp desc D6SP2 Roy Lambert
Mon, Feb 6 2006 11:51 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << I've just tried setting a master-detail relationship using a compound index with a descending part of the index and the IDE chokes on it telling me there isn't an index for the field Index is integer ; timestamp desc >> It's a Borland compatibility thing. You can't use descending indexes with master-detail links. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Feb 6 2006 12:25 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim Oh yes you can - at least if the first part is not descending and that's all you use Roy Lambert
Tue, Feb 7 2006 11:20 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Oh yes you can - at least if the first part is not descending and that's all you use >> I know it can be done (, it's just that the standard index functionality for dealing with linkages like this in the db.pas unit specifically excludes descending indexes. -- Tim Young Elevate Software www.elevatesoft.com