request.pat = CreateObject("component","components.general.patients").init(); GetM = request.pat.medslist(#url.id#); SELECT * FROM GetM WHERE Status = 0 AND N0415 IS NOT NULL SELECT * FROM GetM WHERE Status = 0 AND N0415 IS NULL request.ass = CreateObject("component","components.general.assessments").init(); AssForms = request.ass.get_assess(#url.ID#,#url.assid#); UPDATE #Request.prefix_db_agency#.pAssessments SET F136 = , F137 = , F138 = , F139 = , F140 = , F141 = , F142 = , F143 = , F144 = , F145 = , F146 = , F147 = , F148 = , F85 = , F86 = , F87 = , F88 = , F89 = , F90 = , F91 = , F92 = , F93 = , F94 = , F95 = , F96 = , F97 = , F98 = , F99 = , F100 = , F101 = , F102 = , F103 = , F104 = , F105 = , F106 = , F107 = , F108 = , F110 = , Record_Mod_Date = WHERE Assmt_ID = ANd status = 0 request.general = CreateObject("component","components.general.general").init(); request.ass = CreateObject("component","components.general.assessments").init(); request.soc_wizard = CreateObject("component","components.general.soc_wizard").init(); get_ass = request.general.get_answers('assessment_type','assessment_form'); getmess = request.general.get_messages('assessment_form'); AssForm = request.ass.get_assess(#url.ID#,#url.assid#); SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = AND Patient_ID = AND Admit_ID = ORDER BY F178 DESC