Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBC population through code
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00450927
Message ID:
00450939
Vues:
30
>I have a 2.6 app that I am bringing forward into VFP. 150 + tables.
>
>Is there any way to populate the DBC with references to the tables and have it mark the .dbf headers with it's reference?
>
>I also need to manipulate relationships. I have a dbf that has 186 unique relaionships that I need to establish out of this mess. How do I do that in the DBC?
>
>__Stephen
** add tables
Set Exclusive On

Open Data mydatabase
Add Table myparent
Alter Table myparent Add Primary Key iid

Add Table mychild
** add relationship
** this also creates the index
Alter Table mychild Add Foreign Key Tag iparid ;
  References myparent Tag iid
HTH
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform