% ' main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim Query Dim Content Dim Content2 Dim EnshuName Dim MasterEnshu Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then EnshuName = "" & Content.Fields("演習名称") MasterEnshu = "" & Content.Fields("マスター演習") End If '0件になったら税率0%を自動作成 Query = "" Query = Query & " " Query = Query & " SELECT * " Query = Query & " FROM TDA消費税率M " Query = Query & " WHERE システムCD = '" & GB_SystemCD & "' " Query = Query & " AND 演習CD = '" & EnshuCD & "' " Set Content = OpenQuery(Query) If Content.BOF Or Content.EOF Then Query = "" Query = Query & " " Query = Query & " INSERT INTO TDA消費税率M (システムCD, 演習CD, 消費税率, 標準, 運送費標準) " Query = Query & " VALUES ('" & GB_SystemCD & "', '" & EnshuCD & "', 0, '1', '1') " Set Content = OpenQuery(Query) End If Dim MSG MSG = Request("MSG") If MSG = "Update" Then MSG = "更新しました" End If %> <% = HtmlHeader("") %>
<% = HtmlFooter %> <% End Sub %>