Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
to DBC or not (again) in VFP
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
to DBC or not (again) in VFP
Miscellaneous
Thread ID:
00005839
Message ID:
00005839
Views:
81
(Sigh) I guess I just dont get it. I don't see
how the DBC does anything for me. My tables are
related on a field that is holding a unique ID
number that will NEVER change. I could see if the
table linking info was, let's say, a last name.
A girl gets married and changes her last name.
That change would be automatically carried through
all the child tables...and I tried it...and it works
great, and that's cool, but none of my data is in
this situation.

Let's say I SQL-insert a record in the parent
table that sets the primary index field to some
value:
1) Will the database automatically SQL-insert records
in all the child tables with the same value in the
related fields?
2) If I delete a record in the parent will the
database auto-delete the corresponding data records
in all the child tables?
3) If I say OPEN DATABASE MYDBC will the database
automatically USE all the tables in the database
and SET RELA TO all the relationships created with
the database designer?

If not, besides the integrity and duplicate record
control (both of which are not a prob),
what's the point??

John
John Morga
Sr. Manager Information Systems
Applications Development Group
Systems Engineer
Telephonics Corporation
http://www.telephonics.com
Next
Reply
Map
View

Click here to load this message in the networking platform