Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index problem
Message
De
29/06/1999 17:05:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00235524
Message ID:
00235529
Vues:
26
This message has been marked as the solution to the initial question of the thread.
>Hi!
>
> Let's me describe my problem:
> I have a DataDictionary.DBC which contains several tables, one of them is DataDict, which describes all fields in all my tables, another table is IndxDict, which describes indexes in all my tables. It has this structure:
>Table - Character (name of table)
>TagName - Character
>IndexExpr - Memo
>Type - Character (Primary, Regular, Candidate, etc.)
>Filter - Memo.
>
> As you can guess, this DataDictionary uses to generate our life DataBase with all tables and Indexes.
>
> I wrote a code for table generating, but have some problems with Indexes.
>
> In help I read:
>
> INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName]
> [FOR lExpression]
> [COMPACT]
> [ASCENDING | DESCENDING]
> [UNIQUE | CANDIDATE]
> [ADDITIVE]
>
> I didn't see Primary or Regular here in this Syntax.
>
> Could you please help me with this? I mean, which command I need to use to create indexes using my IndxDict.
>
> Your help will be really appreciated.

ALTER TABLE 'WCSTATUS' ADD PRIMARY KEY CSTATUSID TAG CSTATUSID
You may runGenDbc utility which will give you exactly what you're looking for, no additional tables, etc. needed.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform