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