Re: [GENERAL] Prevent from Deletion

2003-09-01 Thread Doug McNaught
Alex <[EMAIL PROTECTED]> writes: > Hi, > I have tables that have default records that must not be deleted or > modified. > Is there an easy way to do this. Like setting a trigger on the Primary > key value ? You could do this--create ON UPDATE and ON DELETE triggers that look for distinguishing f

[GENERAL] Prevent from Deletion

2003-09-01 Thread Alex
Hi, I have tables that have default records that must not be deleted or modified. Is there an easy way to do this. Like setting a trigger on the Primary key value ? Alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the