Mapping VFP R.I. Rules to SQL Relationships

Author Message
 Posted 10/31/2013 10:32:40 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 12/8/2014 4:29:38 AM
Posts: 80, Visits: 239
Hello,

I have the following relationship in a VFP database:

Parent TableUpdateDeleteInsertChild Table
TableARestrictRestrictIgnoreTableB
What would the equivalent be in a SQL Foreign Key Relationship (alter table code example would be helpful), and how would I set that up in the DDT?

Thanks.

Bill
Post #32262
Add to Twitter Add to Facebook
 Posted 11/14/2013 6:49:20 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 12/8/2014 4:29:38 AM
Posts: 80, Visits: 239
FYI - The only way to "Ignore" inserted FK records that do not have a corresponding PK record is to use .NULL.

This doesn't work for my scenario, but that's how this VFP functionality could be set up in SQL.
Post #32299
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.