UPDATE #Request.prefix_db_agency#.Pathway_Details set Description='#Form.txtDescription#' ,Care_Pathway='#Form.Care_Pathway#' ,Skill='#Form.Skill#' ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' where assessment_id = #Session.AID# AND pathway_details_id = #Session.pwd_id# UPDATE #Request.prefix_db_agency#.Pathway_Details set Deleted= 'Yes' ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' where assessment_id = #Session.AID# AND pathway_details_id = #Session.pwd_id# UPDATE #Request.prefix_db_agency#.Pathway_Details set Deleted= 'Yes' ,Record_Mod_Date='#DateFormat(Now(),"yyyy-mm-dd")#' ,Record_Modified_By='#session.EmployeeID#' where assessment_id = #Session.AID# AND pathway_details_id = #Session.pwd_id#