473,327 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Foriegn Key constraints not enforced when using rules

Bob
Hi,

Does anyone know why forgein key constraints are not enforced when
updateing multiple tables using a combination of views and rules?

This doesn't seem to be a major problem as I can specify the columns
in question as not null and this will produce an ExecInsert error if
the data is not present in my insert.

However, it seems to me that it would be better to be able to rely on
my foreign key constraints.

Why are they ignored?

Thanks in advance,
Nov 12 '05 #1
1 1428
Bob
bo********@hotmail.com (Bob) wrote in message news:<b5*************************@posting.google.c om>...
Hi,

Does anyone know why forgein key constraints are not enforced when
updateing multiple tables using a combination of views and rules?

This doesn't seem to be a major problem as I can specify the columns
in question as not null and this will produce an ExecInsert error if
the data is not present in my insert.

However, it seems to me that it would be better to be able to rely on
my foreign key constraints.

Why are they ignored?

Thanks in advance,


Please ignore this - I've realised that my foriegn keys are behaving
just as they should be. NULLs are handled differently.

Thanks,
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Saqib Ali | last post by:
I have created 2 tables in my MySQL database. A_TAB and B_TAB. They have auto-incrementing integer primary keys respectively named A_ID & B_ID. When I created B_TAB, I declared a field named A_ID...
3
by: RAD | last post by:
I am working with an evaluation copy of SQL Server 2000 for the first time; my DB experience lies with MS Access. I have a simple table in SQL Server (tblCompany) that has a field called...
1
by: jason_s_ford | last post by:
I have several sql server databases that were recently moved to a new server. In the process of migrating the databases, any triggers and constraints attached to tables were removed on accident. ...
10
by: serge | last post by:
I am doing a little research on Google about this topic and I ran into this thread: ...
2
by: AK | last post by:
My understanding is that unlike CHAEK and FOREIGN KEY constraints, we cannot have UNIQUE ones NOT ENFORCED, and the reason is very simple: UNIQUE constraints are implemented as UNIQUE indexes. One...
3
by: Marek Berkan | last post by:
Hi, I have a problem with deffering constraints with db2. It was explained five year ago at this same group...
0
by: Frnak McKenney | last post by:
One part of a customer project I'm working on involves what seem like fairly straightforward updates to a set of related tables. While I've developed software for a number of years (it only seems...
3
by: Rico | last post by:
Hello, I have a foreign key constraint between two tables (Appointments and MissedAppointmentReasons) and I'd like to allow null values in Appointments table for the field containing the...
2
by: raghunana | last post by:
hello friends, i am a beginer.I was unable to add a foriegn key constraint to my NAMES table which refers my EMPLOYEE TABLE SQL> desc employee Name Null? ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.