How back end constraints can affect the front end?,urgent [message #85381] |
Mon, 21 June 2004 03:07 |
Prick
Messages: 11 Registered: June 2004
|
Junior Member |
|
|
Hi all
I am having some Foreign key constraints in some of my tables
and i have created the screens for those tables in the front end.
Now i want to disable/drop these foriegn key constraints,but i am getting afraid to do so because it may affect my front end screens, i want to know that
Whether my screens will work normaly and works as a master detail or not, if i will drop/disable the constraints from back end?
if it does, what i have to do to overcome it
any one , please help me it is urgent
Akhilesh
|
|
|
|
|
Re: How back end constraints can affect the front end?,urgent [message #85387 is a reply to message #85386] |
Mon, 21 June 2004 05:48 |
Himanshu
Messages: 457 Registered: December 2001
|
Senior Member |
|
|
Why in first place do you want to drop Backend Constraints?
If you do so and if somebody enters some Junk data into your Detail table then he will not be stopped although no Coresponding Master exists in the Database.
This will have major problems of Data integrity in your System.
HTH
Regards
Himanshu
|
|
|
Re: How back end constraints can affect the front end?,urgent [message #85389 is a reply to message #85387] |
Mon, 21 June 2004 21:25 |
Prick
Messages: 11 Registered: June 2004
|
Junior Member |
|
|
Hi,
I am dropping the constraints because i am writing some database triggers, to insert update and delete detail table if master is being updated or modified.
Even if i am writing these triggers Do i need to keep the constraints or i have to drop it?
Waiting for your replay
Akhilesh
|
|
|
|