SQLコマンドの入力パラメータの数
mysticage
投稿数: 77
dbMagicV8での開発です。
SQLコマンドで以下のようなSQLを記載しました。
(長文で申し訳ありません。)
入力パラメータの数が22個のつもりですが、実際は32個まで入力可能になります。
また、実行しますと「SQL文の入力パラメータが正しくありません」と左下にメッセージが表示されます。
入力パラメータの記載に何か問題があるのでしょうか?
ちなみに、同じSQL文をdbMagicV10で入力しましたら、入力パラメータの数は想定通り22個になりました。
よろしくお願い致します。
SELECT J.syukkahi, J.syukkaji, H.tokuicd,
max(uri_tokui_mst.tokuime), max(uri_tokui_mst.zeikazeikbn),
max(J.hassoume), max(J.yusouhou), max(J.yusoubin),
sum(case when M.syohincd =':1' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':2' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':3' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':4' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':5' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':6' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':7' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':8' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':9' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':10' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':11' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':12' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':13' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':14' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':15' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':16' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':17' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':18' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':19' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':20' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd not in (':1', ':2', ':3', ':4', ':5', ':6', ':7', ':8', ':9', ':10', ':11', ':12', ':13', ':14', ':15', ':16', ':17', ':18', ':19', ':20') and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
max(case when M.syohincd =':1' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':2' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':3' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':4' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':5' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':6' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':7' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':8' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':9' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':10' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':11' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':12' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':13' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':14' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':15' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':16' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':17' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':18' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':19' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':20' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':1' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':2' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':3' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':4' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':5' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':6' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':7' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':8' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':9' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':10' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':11' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':12' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':13' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':14' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':15' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':16' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':17' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':18' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':19' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':20' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
sum(case when M.syohincd =':1' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':2' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':3' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':4' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':5' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':6' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':7' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':8' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':9' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':10' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':11' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':12' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':13' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':14' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':15' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':16' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':17' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':18' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':19' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':20' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd not in (':1', ':2', ':3', ':4', ':5', ':6', ':7', ':8', ':9', ':10', ':11', ':12', ':13', ':14', ':15', ':16', ':17', ':18', ':19', ':20') and M.gyokbn in (8,9) then M.nohinsuu else 0 end)
FROM (((uri_urinitim_dat as M left join uri_urinitih_dat as H on M.seikyucd=H.seikyucd
and M.tokuicd=H.tokuicd and M.denpyohiduke=H.denhiduke
and M.datakbn=H.datakbn and M.juflag=H.juflag
and M.datasyu=H.datasyu and M.denpyono=H.denpyono) inner join juc_juchu_dat as J
on M.seikyucd=J.seikyucd and M.tokuicd=J.tokuicd
and M.denpyohiduke=J.denhiduke and M.datakbn=J.datakbn
and M.juflag=J.juflag and M.datasyu=J.datasyu
and M.denpyono=J.denpyono) left join uri_tokui_mst on M.tokuicd=uri_tokui_mst.tokuicd) left join com_kbn_mst
on com_kbn_mst.sikibetu='JKB' and J.juchukbn=com_kbn_mst.kbncd
WHERE J.syukkahi between ':21' and ':22' and rtrim(com_kbn_mst.createhi)='2' and H.sakujoflg <> '9'
GROUP BY J.syukkahi, J.syukkaji, H.tokuicd, H.denpyono
ORDER BY J.syukkahi, J.syukkaji, H.tokuicd, H.denpyono
SQLコマンドで以下のようなSQLを記載しました。
(長文で申し訳ありません。)
入力パラメータの数が22個のつもりですが、実際は32個まで入力可能になります。
また、実行しますと「SQL文の入力パラメータが正しくありません」と左下にメッセージが表示されます。
入力パラメータの記載に何か問題があるのでしょうか?
ちなみに、同じSQL文をdbMagicV10で入力しましたら、入力パラメータの数は想定通り22個になりました。
よろしくお願い致します。
SELECT J.syukkahi, J.syukkaji, H.tokuicd,
max(uri_tokui_mst.tokuime), max(uri_tokui_mst.zeikazeikbn),
max(J.hassoume), max(J.yusouhou), max(J.yusoubin),
sum(case when M.syohincd =':1' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':2' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':3' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':4' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':5' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':6' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':7' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':8' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':9' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':10' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':11' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':12' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':13' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':14' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':15' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':16' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':17' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':18' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':19' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':20' and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd not in (':1', ':2', ':3', ':4', ':5', ':6', ':7', ':8', ':9', ':10', ':11', ':12', ':13', ':14', ':15', ':16', ':17', ':18', ':19', ':20') and M.gyokbn not in (8,9) then M.nohinsuu else 0 end),
max(case when M.syohincd =':1' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':2' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':3' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':4' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':5' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':6' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':7' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':8' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':9' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':10' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':11' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':12' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':13' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':14' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':15' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':16' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':17' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':18' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':19' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':20' and M.gyokbn not in (8,9) then M.nohinirisu else 0 end),
max(case when M.syohincd =':1' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':2' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':3' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':4' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':5' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':6' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':7' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':8' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':9' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':10' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':11' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':12' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':13' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':14' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':15' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':16' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':17' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':18' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':19' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
max(case when M.syohincd =':20' and M.gyokbn not in (8,9) then M.boalirisu else 0 end),
sum(case when M.syohincd =':1' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':2' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':3' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':4' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':5' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':6' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':7' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':8' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':9' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':10' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':11' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':12' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':13' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':14' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':15' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':16' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':17' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':18' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':19' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd =':20' and M.gyokbn in (8,9) then M.nohinsuu else 0 end),
sum(case when M.syohincd not in (':1', ':2', ':3', ':4', ':5', ':6', ':7', ':8', ':9', ':10', ':11', ':12', ':13', ':14', ':15', ':16', ':17', ':18', ':19', ':20') and M.gyokbn in (8,9) then M.nohinsuu else 0 end)
FROM (((uri_urinitim_dat as M left join uri_urinitih_dat as H on M.seikyucd=H.seikyucd
and M.tokuicd=H.tokuicd and M.denpyohiduke=H.denhiduke
and M.datakbn=H.datakbn and M.juflag=H.juflag
and M.datasyu=H.datasyu and M.denpyono=H.denpyono) inner join juc_juchu_dat as J
on M.seikyucd=J.seikyucd and M.tokuicd=J.tokuicd
and M.denpyohiduke=J.denhiduke and M.datakbn=J.datakbn
and M.juflag=J.juflag and M.datasyu=J.datasyu
and M.denpyono=J.denpyono) left join uri_tokui_mst on M.tokuicd=uri_tokui_mst.tokuicd) left join com_kbn_mst
on com_kbn_mst.sikibetu='JKB' and J.juchukbn=com_kbn_mst.kbncd
WHERE J.syukkahi between ':21' and ':22' and rtrim(com_kbn_mst.createhi)='2' and H.sakujoflg <> '9'
GROUP BY J.syukkahi, J.syukkaji, H.tokuicd, H.denpyono
ORDER BY J.syukkahi, J.syukkaji, H.tokuicd, H.denpyono
投票数:0
平均点:0.00
投稿ツリー
-
SQLコマンドの入力パラメータの数
(mysticage, 2014-10-24 15:34)
- Re: SQLコマンドの入力パラメータの数 (ISHIJIMA, 2014-10-25 13:25)
- Re: SQLコマンドの入力パラメータの数 (Kurogane, 2014-10-27 14:25)