UPDATE #Request.prefix_db_agency#.Payments SET Amount = #NumberFormat(form.Paid,'_____.__')#, writeoffamount = #NumberFormat(form.WriteOff,'_____.__')#, PaymentDate = #CreateODBCDateTime(form.Date)# ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Payment_ID = #form.Payment_ID# UPDATE #Request.prefix_db_agency#.Invoices SET invoiceTotal = #NumberFormat(form.InvoiceTotal,'_____.__')# ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Invoice_ID = #form.Invoice_ID# #form.Date#