StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Mapping VFP R.I. Rules to SQL Relationships

Mapping VFP R.I. Rules to SQL Relationships

William Fields — Thu, 14 Nov 2013 12:49:20 GMT

Hello,

I have the following relationship in a VFP database:

Parent Table	Update	Delete	Insert	Child Table
TableA	Restrict	Restrict	Ignore	TableB

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

RE: Mapping VFP R.I. Rules to SQL Relationships

William Fields — Thu, 14 Nov 2013 12:49:20 GMT

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.