出来るのだＡＳＰＱ＆Ａ掲示板（過去ＬＯＧ）

出来るのだＡＳＰＱ＆Ａ掲示板（過去ＬＯＧ） 　訪問数 52046 昨日 889 今日 776
【PR】パソコン入門からIT専門書まで幅広く取り揃えています。セブン-イレブン受取り手数料無料のセブンアンドワイ。

Topに戻る

掲示板に戻る

検索

削除

管理者

[5441] SQLでカンマがありませんTO

コメントする

投稿者：モリコロさん 2005/11/02 13:33:10

Sub INSERT_QUERY
SQL = "INSERT INTO 商品ワーク("
SQL = SQL & "商品コード,"
SQL = SQL & "正式品名,"
SQL = SQL & "正式規格,"
SQL = SQL & "正式品名カナ,"
SQL = SQL & "正式規格カナ,"
SQL = SQL & "短縮品名,"
SQL = SQL & "短縮規格,"
SQL = SQL & "短縮品名カナ,"
SQL = SQL & "短縮規格カナ,"
SQL = SQL & "ブランド名,"

SQL = SQL & "仕入先コード,"
SQL = SQL & "JANコード,"
SQL = SQL & "ボールITF,"
SQL = SQL & "ケースITF,"

SQL = SQL & "ボール入数,"
SQL = SQL & "ケース入数,"
SQL = SQL & "発注単位,"
SQL = SQL & "単品幅,"
SQL = SQL & "単品奥,"
SQL = SQL & "単品高さ,"
SQL = SQL & "ボール幅,"
SQL = SQL & "ボール奥,"
SQL = SQL & "ボール高さ,"
SQL = SQL & "ケース幅,"
SQL = SQL & "ケース奥,"
SQL = SQL & "ケース高さ,"

SQL = SQL & "旧仕入単価,"
SQL = SQL & "旧二次卸単価,"
SQL = SQL & "旧標準卸単価,"
SQL = SQL & "旧標準小売単価,"

SQL = SQL & "新仕入単価,"
SQL = SQL & "新二次卸単価,"
SQL = SQL & "新標準卸単価,"
SQL = SQL & "新標準小売単価,"
SQL = SQL & "展示会価格,"
SQL = SQL & "粗利率,"

SQL = SQL & "発売日,"

SQL = SQL & "種類,"

SQL = SQL & "種別,"
SQL = SQL & "内容,"
SQL = SQL & "形状,"
SQL = SQL & "対象,"
SQL = SQL & "用途,"
SQL = SQL & "細分,"
SQL = SQL & "JICFS,"

SQL = SQL & "材質,"
SQL = SQL & "色,"
SQL = SQL & "電源,"
SQL = SQL & "内容量,"
SQL = SQL & "単品重量,"
SQL = SQL & "ボール重量,"
SQL = SQL & "ケース重量,"

SQL = SQL & "商品説明,"
SQL = SQL & "キャッチコピー01,"
SQL = SQL & "キャッチコピー02,"

SQL = SQL & "消費電力,"
SQL = SQL & "付属品,"
SQL = SQL & "製造,"
SQL = SQL & "輸入区分,"

SQL = SQL & "インストア区分,"
SQL = SQL & "手打ち区分,"
SQL = SQL & "処理区分,"
SQL = SQL & "PB区分,"
SQL = SQL & "廃番区分,"
SQL = SQL & "展示会集計区分,"
SQL = SQL & "更新日,"
SQL = SQL & "登録日,"
SQL = SQL & "オフコン品種)"

SQL = SQL & " VALUES("
SQL = SQL & CLNG(Trim(SYOHIN_CD)) & ",'"
SQL = SQL & Trim(SEI_HIN) & "','"
SQL = SQL & Trim(SEI_KIKAKU) & "','"
SQL = SQL & Trim(SEI_HIN_KANA) & "','"
SQL = SQL & Trim(SEI_KIKAKU_KANA) & "','"
SQL = SQL & Trim(TAN_HIN) & "','"
SQL = SQL & Trim(TAN_KIKAKU) & "','"
SQL = SQL & Trim(TAN_HIN_KANA) & "','"
SQL = SQL & Trim(TAN_KIKAKU_KANA) & "','"
SQL = SQL & Trim(BRAND) & "',"

SQL = SQL & CLNG(Trim(SIIRE_CD)) & ",'"
SQL = SQL & Trim(JAN) & "','"
SQL = SQL & Trim(BOWL_ITF) & "','"
SQL = SQL & Trim(CASE_ITF) & "',"

SQL = SQL & CLNG(Trim(BOWL_IRISU)) & ","
SQL = SQL & CLNG(Trim(CASE_IRISU)) & ","
SQL = SQL & CLNG(Trim(HACHU_TANI)) & ","
SQL = SQL & CLNG(Trim(TAN_HABA)) & ","
SQL = SQL & CLNG(Trim(TAN_OKU)) & ","
SQL = SQL & CLNG(Trim(TAN_TAKASA)) & ","
SQL = SQL & CLNG(Trim(BOWL_HABA)) & ","
SQL = SQL & CLNG(Trim(BOWL_OKU)) & ","
SQL = SQL & CLNG(Trim(BOWL_TAKASA)) & ","
SQL = SQL & CLNG(Trim(CASE_HABA)) & ","
SQL = SQL & CLNG(Trim(CASE_OKU)) & ","
SQL = SQL & CLNG(Trim(CASE_TAKASA)) & ","

SQL = SQL & CLNG(Trim(OLD_SIIRE_TAN)) & ","
SQL = SQL & CLNG(Trim(OLD_NIJI_TAN)) & ","
SQL = SQL & CLNG(Trim(OLD_ORO_TAN)) & ","
SQL = SQL & CLNG(Trim(OLD_KOURI_TAN)) & ","

SQL = SQL & CLNG(Trim(NEW_SIIRE_TAN)) & ","
SQL = SQL & CLNG(Trim(NEW_NIJI_TAN)) & ","
SQL = SQL & CLNG(Trim(NEW_ORO_TAN)) & ","
SQL = SQL & CLNG(Trim(NEW_KOURI_TAN)) & ","
SQL = SQL & CLNG(Trim(TENJI_GAKU)) & ","
SQL = SQL & CLNG(Trim(ARARI)) & ","

SQL = SQL & Trim(HATUBAI) & "','"

SQL = SQL & CLNG(Trim(SYURUI)) & ","

SQL = SQL & CLNG(Trim(SYUBETU)) & ","
SQL = SQL & CLNG(Trim(NAIYO)) & ","
SQL = SQL & CLNG(Trim(KEIJO)) & ","
SQL = SQL & CLNG(Trim(TAISHO)) & ","
SQL = SQL & CLNG(Trim(YOUTO)) & ","
SQL = SQL & CLNG(Trim(SAIBUN)) & ","
SQL = SQL & CLNG(Trim(JICFS)) & ",'"

SQL = SQL & Trim(ZAISITU) & "','"
SQL = SQL & Trim(COLOR) & "','"
SQL = SQL & Trim(DENGEN) & "',"
SQL = SQL & CLNG(Trim(NAIYORYO)) & ","

SQL = SQL & CLNG(Trim(TAN_JURYO)) & ","
SQL = SQL & CLNG(Trim(BOWL_JURYO)) & ","
SQL = SQL & CLNG(Trim(CASE_JURYO)) & ",'"

SQL = SQL & Trim(SETUMEI) & "','"
SQL = SQL & Trim(C_COPY01) & "','"
SQL = SQL & Trim(C_COPY02) & "',"

SQL = SQL & CLNG(Trim(DENRYOKU)) & ",'"
SQL = SQL & Trim(FUZOKU) & "',"
SQL = SQL & CLNG(Trim(SEIZO)) & ","
SQL = SQL & CLNG(Trim(YUNYU)) & ","

SQL = SQL & CLNG(Trim(INSTORE)) & ","
SQL = SQL & CLNG(Trim(TEUCHI)) & ","
SQL = SQL & CLNG(Trim(SYORI)) & ","
SQL = SQL & CLNG(Trim(PB)) & ","
SQL = SQL & CLNG(Trim(HAIBAN)) & ","
SQL = SQL & CLNG(Trim(TENJI_SYUKEI)) & ",'"
SQL = SQL & Trim(KOUSIN) & "','"
SQL = SQL & Trim(TOROKU) & "',"
SQL = SQL & CLNG(Trim(OP_HINSHU)) & ")"

削除する

SQLでカンマがありませんTO 　モリコロさん [2005/11/02 13:33:10] [5441]

SQLでカンマがありませんTO 　モリコロさん [2005/11/02 13:39:37] [5442]
　

SQLでカンマがありませんとエラーが出てしまいます。　モリコロさん [2005/11/02 13:48:56] [5443]
　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 15:21:32] [5444]
　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　モリコロさん [2005/11/02 16:55:50] [5445]
　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 17:07:08] [5446]
　　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　モリコロさん [2005/11/02 17:51:33] [5447]
　　　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 18:15:25] [5448]
　　　　　　　

Re:SQLでカンマがありませんとエラーが出てしまいます。　はやしさん [2005/11/02 18:24:31] [5449]

TreeBBS For ASP V.0.1.3
Program By ＹａｓＮｅｔ