dbTalk Databases Forums  

VFP 6 .dbc FK RI

comp.databases.xbase.fox comp.databases.xbase.fox


Discuss VFP 6 .dbc FK RI in the comp.databases.xbase.fox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gene Wirchenko
 
Posts: n/a

Default VFP 6 .dbc FK RI - 01-27-2006 , 03:31 PM






I have a couple tables where one has an FK into the other. How
do I get the FK enforcement code into the .dbc in the first place?
gendbc does not do it.

Sincerely,

Gene Wirchenko


Reply With Quote
  #2  
Old   
Dan Freeman
 
Posts: n/a

Default Re: VFP 6 .dbc FK RI - 01-27-2006 , 03:53 PM






If you have relations based on the pk/fk, run the Referential Integrity
wizard.

(Open the database, right click, and choose Referential Integrity.)

Dan

Gene Wirchenko wrote:
Quote:
I have a couple tables where one has an FK into the other. How
do I get the FK enforcement code into the .dbc in the first place?
gendbc does not do it.

Sincerely,

Gene Wirchenko



Reply With Quote
  #3  
Old   
Cindy Winegarden
 
Posts: n/a

Default Re: VFP 6 .dbc FK RI - 01-27-2006 , 04:47 PM



Hi Gene,

Just to add, GenDBC only creates code to duplicate what you already have. It
doesn't add anything like RI.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden (AT) msn (DOT) com www.cindywinegarden.com


"Gene Wirchenko" <genew (AT) ucantrade (DOT) com.NOTHERE> wrote

Quote:
I have a couple tables where one has an FK into the other. How
do I get the FK enforcement code into the .dbc in the first place?
gendbc does not do it.

Sincerely,

Gene Wirchenko




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.