about Triggers ?

Question

good morning ih vae a firebird database in c# i have 2 tables patients and consultations i want create trigger block delete if patient have consultation so if code_pat in consultations table thank you good day

Bikesh Srivastava · Answer

Hi, you don't need to create trigger,you can use merge query to resolve your problem. https://bikeshsrivastava.blogspot.in/2016/07/part-28-what-is-merge-query-in-sql.html

Nitin Sontakke · Answer

Why not just create a foreign key constraint, which will automatically restrict the deletion and you (hopefully) will also get a trappable exception which you can convert into a use friendly message.

dzconception · Answer

this triger is writen in sqlserver i want it in firbird please ?

Rajeev Punhani · Answer

Hi, CREATE TRIGGER [dbo].[patient_InsteadOfDELETE] ON [dbo].[patient] INSTEAD OF DELETE AS BEGIN SET NOCOUNT ON ; DECLARE @patientid INT SELECT @patientid=DELETED.patientid FROM DELETED IF( select count (*) from consultations where code_pat=@patientid2>0) BEGIN RAISERROR( 'Recordcannotbedeleted' ,16,1) ROLLBACK END ELSE BEGIN DELETE FROM patient WHERE PatientId=@patientid END END please use the column namesbased on your table.

dzconception · Answer

thank yoy again but i have probleme with this code in firebird on declare SET TERM ^ ; CREATE TRIGGER TRIGGER01 FOR PATIENTS ACTIVE BEFORE DELETE POSITION 0 AS BEGIN SETNOCOUNTON DECLARE VARIABLE patientid INTEGER begin SELECT patientid=DELETED.patientid FROMDELETED IF(selectcount(*)fromconsultationswherecode_pat=@patientid2>0) BEGIN RAISERROR( 'Recordcannotbedeleted' ,16,1) ROLLBACK END ELSE BEGIN DELETEFROMpatient WHEREPatientId=@patientid END END end ^ SET TERM ; ^

Rajeev Punhani · Answer

Hi, Please see the below link http://www.aspsnippets.com/Articles/SQL-Server-Instead-Of-Delete-Trigger-Example.aspx

about Triggers ?

Answers (6)