<%@LANGUAGE="VBSCRIPT"%> <% '===================================================== '| | '| _DeleteBuildStandard '| | '===================================================== %> <% Option explicit Response.Expires = 0 %> <% '------------ ACCESS CONTROL ------------------ %> <% '------------ VARIABLE DEFINITION ------------- '------------ CONSTANTS DECLARATION ----------- '------------ VARIABLE INIT ------------------- '------------ CONDITIONS ---------------------- '---------------------------------------------- %> <% '-------------------------------------------------------------------------------------------------------------------------- Sub DeleteBuildStandard (bsa_id) On Error Resume Next OraDatabase.Parameters.Add "BSA_ID", bsa_id, ORAPARM_INPUT, ORATYPE_NUMBER objEH.TryORA ( OraSession ) OraDatabase.ExecuteSQL "BEGIN DELETE FROM BUILD_STANDARDS_ADDENDUM WHERE BSA_ID = :BSA_ID; END;" objEH.CatchORA ( OraSession ) OraDatabase.Parameters.Remove "BSA_ID" End Sub '-------------------------------------------------------------------------------------------------------------------------- %> <% '**************************** M A I N ****************************** ' --- Form is Valid --- Call DeleteBuildStandard(Request("bsa_id")) If objEH.Finally Then Call OpenInWindow ("admin_gbe_buildstandard.asp") End If '********************************************************************** %> <% '------------ RUN AFTER CODE RUN -------------- '---------------------------------------------- '---------------------------------------------- Call Destroy_All_Objects %>