coding_track = CreateObject("Component", "coding"); requested_logged_elapsed = coding_track.calc_elapse(req_datetime,now()); INSERT INTO #Request.prefix_db_lookup#.Coding_Request (Agency_ID,Request_Date,Last_Name,First_Name,Assessment_Type, Assessment_Date, Assigned_to, Coding_status, Assigned_by, Notes, message_indicate, Request_Time, Contacts, MHCB_Entered,time_requested,Updated_by,requested_logged_elapsed) VALUES ('#form.Agency_name#','#DateFormat(form.Request_Date,"yyyy-mm-dd")#','#form.Last_Name#','#form.First_Name#','#form.Assessment_Type#', '#DateFormat(form.Assessment_Date,"yyyy-mm-dd")#', '#form.Assigned_to#', '#form.Coding_status#', '#form.Assigned_by#', '#form.Notes#', '#form.messageindicate#', '#form.RequestTime#', '#form.Contacts#', #now()#,#now()#,'#Session.MM_USID#','#requested_logged_elapsed#') UPDATE IGNORE #Request.prefix_db_lookup#.Coding_Request SET Agency_ID = '#form.Agency_name#', Request_Date = '#DateFormat(form.Request_Date,"yyyy-mm-dd")#', Last_Name = '#form.Last_Name#', First_Name = '#form.First_Name#', Assessment_Type = '#form.Assessment_Type#', Completed_Date = '#DATEFORMAT(now(),"yy-mm-dd")#', waiting_approval_date = '#DATEFORMAT(now(),"yy-mm-dd")#', Assessment_Date = '#DateFormat(form.Assessment_Date,"yyyy-mm-dd")#', Assigned_to = '#form.Assigned_to#', requested_logged_elapsed = '#requested_logged_elapsed#', Coding_status = '#form.Coding_status#', completed_coding = #now()# , completed_oasis = #now()# , completed_1st_message_send = #now()# , completed_OASIS_review = #now()# , completed_1st_approval = #now()# , completed_OASIS_update = #now()# , completed_485_update = #now()# , completed_final_send = #now()# , Assigned_by = '#form.Assigned_by#', Notes = '#form.Notes#',Notes = null, message_indicate = '#form.messageindicate#',message_indicate = null, Request_Time = '#form.RequestTime#', Contacts = '#form.Contacts#', delay_reason = , Updated_by = '#Session.MM_USID#' WHERE ID = #form.ID# coding_track = CreateObject("Component", "coding"); get_result = coding_track.update_status(#form.ID#,#form.Coding_status#);

Updation failure.Please contact you admin.