Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC population through code
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00450927
Message ID:
00450939
Views:
28
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform