Re: How to create (dynamically) a primary index with more than one field?

Article View: borland.public.cppbuilder.database.dbexpress

Article #47

Back to borland.public.cppbuilder.database.dbexpress Previous Next

#47

From: MR
Date: Wed, 27 Jun 2007 06:56

20 lines
1545 bytes

Hello Minas,

thanks for your sample...

Trying around a lot and wondering why your sample does work and mine
did not, I finally found out, that the reason is, when indexing over
more than one field, the fields being index *must* be subsequent.

So inserting a FieldDef between Id and Remark in your sample will
result in the same exception I described.

Is this always the case or is this specific for the data-base type,
i.e. Paradox.

Or is there a way to allow non-subsequent fields being indexed too?


Thanks,

Michael

Technical Details

Message-ID: <6524839q2n65if026g1nnsstepr570ft2l@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <rf3n7353bhv32tvgdbcip16bgsbt0apt89@4ax.com> <467e2a33@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: fb4e2,19b113387146ab80
X-Google-Attributes: gidfb4e2,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: <MR>
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: Re: How to create (dynamically) a primary index with more than one field?
Date: Wed, 27 Jun 2007 08:56:04 +0200
Message-ID: <6524839q2n65if026g1nnsstepr570ft2l@4ax.com>
References: <rf3n7353bhv32tvgdbcip16bgsbt0apt89@4ax.com> <467e2a33@newsgroups.borland.com>
X-Newsreader: Forte Free Agent 3.3/32.846
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 88.64.28.227
X-Trace: newsgroups.borland.com 1182927348 88.64.28.227 (26 Jun 2007 23:55:48 -0700)
Lines: 20
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message