出来るのだＡＳＰ Ｑ＆Ａ掲示板（過去ＬＯＧ） 　訪問数 52046 昨日 889 今日 776
     【PR】 パソコン入門からIT専門書まで幅広く取り揃えています。セブン-イレブン受取り手数料無料のセブンアンドワイ。
Topに戻る 掲示板に戻る 検索 削除 管理者
[5442] SQLでカンマがありませんTO
投稿者：モリコロさん 2005/11/02 13:39:37
> 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 ＹａｓＮｅｔ