Article View: borland.public.cppbuilder.database.dbexpress
Article #51Re: How to create (dynamically) a primary index with more than one field?
From: Minas
Date: Thu, 28 Jun 2007 01:43
Date: Thu, 28 Jun 2007 01:43
43 lines
2311 bytes
2311 bytes
<MR> wrote: > Hmmm? The same in Access? > In Access I got this only when I set FieldDef->FieldNo property.Otherwise is working fine. > by something like a database-explorer to be able to create a > BDE-Paradox-database, like in the former versions? (Perhaps I forgot > to install something or it is a little bit more complicated (or they > really threw it out)? Is this restriction here too? If you mean Database Desktop (I have it in BCB5 PRO), yes ,the fields must be consecutive . I have Turbo C++ Explorer which has only Database Explorer. From the help: "Paradox:The fields in a key must be contiguous starting with the first field" An easy way is to use SQL in Database Explorer(since you haven't DB Desktop) something like: create table testTbl( Id integer, State varchar(25), Remark varchar(10), PRIMARY KEY (Id,Remark) ) and for additional indices create index StateX ON testTbl (State) > But I suppose I could live with this need of reordering my fields... Sure .Is not a big problem anyway. _Minas Harokopos ------ "Only the virtue's conquests have certainty" Sofokleous Erephyle
Technical Details
Message-ID:
<46831298@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<rf3n7353bhv32tvgdbcip16bgsbt0apt89@4ax.com> <467e2a33@newsgroups.borland.com> <6524839q2n65if026g1nnsstepr570ft2l@4ax.com> <46822904@newsgroups.borland.com> <qhr483ph6ukdgtkmo9ne1acnmapuq5qjqd@4ax.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: "Minas" <no email> Newsgroups: borland.public.cppbuilder.database.dbexpress References: <rf3n7353bhv32tvgdbcip16bgsbt0apt89@4ax.com> <467e2a33@newsgroups.borland.com> <6524839q2n65if026g1nnsstepr570ft2l@4ax.com> <46822904@newsgroups.borland.com> <qhr483ph6ukdgtkmo9ne1acnmapuq5qjqd@4ax.com> Subject: Re: How to create (dynamically) a primary index with more than one field? Date: Thu, 28 Jun 2007 04:43:23 +0300 Lines: 45 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 NNTP-Posting-Host: 62.1.57.38 Message-ID: <46831298@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1182995096 62.1.57.38 (27 Jun 2007 18:44:56 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail