INSERT INTO #Request.prefix_db_agency#.CommunicationSubjects ( Agency_ID, Subject, Created_By, Created_Date ) VALUES ( #session.AgencyID#, '#Trim(form.Subject)#', #Session.EmployeeID#, #CreateODBCDateTime(Now())# ) UPDATE #Request.prefix_db_agency#.CommunicationSubjects SET Subject = '#Trim(form.Subject)#', Mod_By = #Session.EmployeeID#, Mod_Date = #CreateODBCDateTime(Now())# WHERE CommSub_ID = #form.CommSub_ID#