ホーム   フォーラム   FAQ
 
メインメニュー
ログイン
ユーザー名:

パスワード:


パスワード紛失

SQLコマンドの入力パラメータの数

  • このフォーラムに新しいトピックを立てることはできません
  • このフォーラムではゲスト投稿が禁止されています
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 .2 | 投稿日時 2014-10-24 15:34
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
投票数:0 平均点:0.00
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2014-10-25 13:25
ISHIJIMA  長老 居住地: 静岡県  投稿数: 1827
V10で問題ないという事はV8の不具合でしょうか?
V8の最新になっていますか?
投票数:1 平均点:0.00
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2014-10-27 14:25
Kurogane  常連   投稿数: 50
V8は8の倍数のパラメータは個数分入力パラメータが増えてしまうという不具合があります。
今回は:8と:16が6つずつあるので、それぞれ5つずつ余分に増えたということです。

余分に増やせますが、増やさずにV10と同じようにパラメータと合わせれば動作するかと思います。
投票数:1 平均点:10.00

  条件検索へ


Copyright (C) Magic Software Japan K.K. All Rights Reserved.
個人情報保護方針 会員規約