INSERT INTO #Request.prefix_db_agency#.Payer_advance ( Payer_ID, TOB, Notes, Supply, Record_Creation_Date ) VALUES ( '#Trim(form.PayerId)#', '#Trim(form.Type_of_Bill)#', '#form.Notes#', '#form.Supply_value#', #CreateODBCDate(Now())# ) UPDATE #Request.prefix_db_agency#.Payer_advance SET TOB = '#Trim(form.Type_of_Bill)#',Notes = '#form.Notes#',Supply = '#form.Supply_value#' Where Payer_advance_ID = '#Trim(form.Payer_advance_ID)#' Encrypted_Payer_ID=encrypt(#form.PayerId#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); DELETE FROM #Request.prefix_db_agency#.Payer_advance Where Payer_advance_ID = '#Trim(url.AID)#' Encrypted_Payer_ID=encrypt(#url.ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex");