ls_sql="if exists(select * from kcckye where kcckye_kjnd="+ls_kjnd+" and kcckye_kjqj="+ls_kjqj+" and kcckye_ckbh="+ls_ckbh+""+&
"and kcckye_wlbh="+ls_wlbh+") update kcckye set kcckye_jslj= kcckye_jslj+li_sl,kcckye_jfsl=kcckye_jfsl+li_sl "+&
"where (kcckye_kjnd=:ls_kjnd and kcckye_kjqj=:ls_kjqj and kcckye_ckbh=:ls_ckbh and kcckye_wlbh=:ls_wlbh) "+&
"else insert into kcckye(kcckye_kjnd,kcckye_kjqj,kcckye_ckbh,kcckye_wlbh,kcckye_jslj,kcckye_jfsl)values("+ls_kjnd+","+ls_kjqj+","+ls_ckbh+","+ls_wlbh+",'+li_sl+','+li_sl+')"
uj5u.com熱心網友回復：
什么錯誤？似乎""應為" "?uj5u.com熱心網友回復：
太亂了uj5u.com熱心網友回復：
只看第1行，后面沒看第一行錯誤：
ls_sql="if exists(select * from kcckye where kcckye_kjnd="+ls_kjnd+" and ...
應該是：
ls_sql="if exists(select * from kcckye where kcckye_kjnd='"+ls_kjnd+"' and ...
uj5u.com熱心網友回復：
太亂,不好分析,把messagebox的結果放到資料庫中執行，就很好查證錯誤所在了。uj5u.com熱心網友回復：
格式不好。中斷代碼，把SQL除錯出來，直接到資料庫中執行試試。
uj5u.com熱心網友回復：
錯誤好多阿，你最后把ls_sql的結果弄出來，慢慢改把uj5u.com熱心網友回復：
ls_sql="if exists(select * from kcckye where kcckye_kjnd='"+ls_kjnd+"' and kcckye_kjqj='"+ls_kjqj+"' and kcckye_ckbh='"+ls_ckbh+"'"+&"and kcckye_wlbh='"+ls_wlbh+"') update kcckye set kcckye_jslj= kcckye_jslj+"+string(li_sl)+",kcckye_jfsl=kcckye_jfsl+"+string(li_sl)+" "+&
"where (kcckye_kjnd='"+ls_kjnd+"' and kcckye_kjqj='"+ls_kjqj+"' and kcckye_ckbh='"+ls_ckbh+"' and kcckye_wlbh='"+ls_wlbh+"') "+&
"else insert into kcckye(kcckye_kjnd,kcckye_kjqj,kcckye_ckbh,kcckye_wlbh,kcckye_jslj,kcckye_jfsl)values('"+ls_kjnd+"','"+ls_kjqj+"','"+ls_ckbh+"','"+ls_wlbh+"',"+string(li_sl)+","+string(li_sl)+")"
錯誤已經給你修改 自己看吧！
uj5u.com熱心網友回復：
把ls_sql的值取出來（比如放到text控制元件上), 然后放到資料庫中分析運行.uj5u.com熱心網友回復：
sql中拼入字符型別變數，要記得加單引號kcckye_kjnd="+ls_kjnd+" and
kcckye_kjnd='"+ls_kjnd+"' and
uj5u.com熱心網友回復：
="+ls_kjnd+" 應為 ='"+ls_kjnd+" ' 依此類推uj5u.com熱心網友回復：
關注 接分uj5u.com熱心網友回復：
有點難度哦轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/112148.html
標籤：數據庫相關
上一篇：急！！pb+myodbc的問題