INSERT INTO #Request.prefix_db_lookup#.pStanding_Orders ( Agency_ID, Description, Date_Created, Created_By, Date_Modified, Modified_by) VALUES (#session.agencyid#,'#form.Description#', #now()#, #Session.EmployeeID#, #now()#, #Session.EmployeeID#) Update #Request.prefix_db_lookup#.pStanding_Orders SET Description='#form.Description#', Date_Modified=#now()#, Modified_by='#Session.EmployeeId#' WHERE ID = '#form.ID#' url.ID=decrypt(#url.ID#,"#application.enckey#","AES","Hex"); UPDATE #Request.prefix_db_lookup#.pStanding_Orders SET Status='1' WHERE ID = '#url.ID#'