trigger

• Jose Espinal

  SSC Enthusiast

  Points: 144

  More actions

  April 22, 2004 at 1:01 pm

  #86576

  I need your help

  I have two tables EP_names and patients(been this last one the child) I added I few fields to patients

  as follow you will find a trigger that I created but it just does not update my patients table, don't know why is not updating

  Your help please

  ALTER TRIGGER Ep_Names_Insert On dbo.Ep_Names After Insert as

  Insert Patients

  Select pkEP_Names as fkEP_Names,

  NULL as fk_name_id_Nurse,

  NULL as fk_name_id_Nurse_CaseMan,

  '' as CaseManagementRationale,

  '' as MonthlySummaryOfServices,

  0 as PatientReportNo,

  '' as ClaimsNotes,

  NULL as FollowUpDate,

  NULL as ClosureDate,

  'Active' as Status,

  '' as 'Active' as Status,

  '' as MiscellaneousNotes,

  '' as Prognosis,

  NULL as PhoneContact,

  NULL as ICD9Code,

  NULL as DiagnosisDate,

  UserName,

  AddDate,

  ModDate,

  NULL as ts,

  Deleted From Inserted

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 23, 2004 at 7:22 pm

  #504112

  Do you get any errors or nothing just happens.

• Jose Espinal

  SSC Enthusiast

  Points: 144

  More actions

  April 26, 2004 at 7:17 am

  #504217

  Thanks for the replay 686

   

  I do not get any error, just nothing happens,