Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%@LANGUAGE="VBSCRIPT"%><%'====================================================='| |'| _DeleteBuildStandard'| |'=====================================================%><%Option explicitResponse.Expires = 0%><!--#include file="common/conf.asp"--><!--#include file="common/globals.asp"--><!--#include file="common/formating.asp"--><!--#include file="common/qstr.asp"--><!--#include file="common/common_subs.asp"--><!--#include file="common/_form_window_common.asp"--><%'------------ ACCESS CONTROL ------------------%><!--#include file="_access_control_general.asp"--><!--#include file="_access_control_login.asp"--><%'------------ VARIABLE DEFINITION -------------'------------ CONSTANTS DECLARATION -----------'------------ VARIABLE INIT -------------------'------------ CONDITIONS ----------------------'----------------------------------------------%><%'--------------------------------------------------------------------------------------------------------------------------Sub DeleteBuildStandard (bsa_id)On Error Resume NextOraDatabase.Parameters.Add "BSA_ID", bsa_id, ORAPARM_INPUT, ORATYPE_NUMBERobjEH.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 ThenCall OpenInWindow ("admin_gbe_buildstandard.asp")End If'**********************************************************************%><%'------------ RUN AFTER CODE RUN --------------'----------------------------------------------'----------------------------------------------Call Destroy_All_Objects%>