16,473
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
mqbwx 2003-08-23
- 打赏
- 举报
没有限制
hucsdn 2003-08-23
- 打赏
- 举报
我的程序就超过了，没问题！
fayifu 2003-08-23
- 打赏
- 举报
没有这个限制!!
wdonghai 2003-08-23
- 打赏
- 举报
怪只怪自己不小心，SQL语句都写错了，谢谢各位
zhouyong0371 2003-08-23
- 打赏
- 举报
应该没有吧？不过如果你的SQL超过了255，我劝你还是把它分解一下再处理吧，肯定可以分多次执行了。255以上，维护的时候太困难了。
caomuyong1 2003-08-23
- 打赏
- 举报
兄弟，好像没有这个限制
wdonghai 2003-08-23
- 打赏
- 举报
CString sqlstr="select pinv.fno,pinv.fdate 发票日期,pro.fbillcode,sup.fname,pinvc.frow,";
sqlstr+="ins.fbillno,ins.fdate ,inss.frkqty,inss.fbatchno,u.name,inss.frow from ";
sqlstr+=DataBase+".t_supplier sup,"+DataBase+".t_user u,"+DataBase+".tic_instock1 ins,";
sqlstr+=DataBase+"tic_instock1items inss,"+DataBase+".tic_compare cp where pinv.fid=";
sqlstr+="cp.fproinvoiceid and prinvc.frow=cp.fproinvoicechildid and ins.fid=cp.finstockid ";
sqlstr+="and inss.frow=cp.finstockchildid and pro.finterid=prinv.fhth and sup.finterid=";
sqlstr+="prinv.fsupplierid";
m_recordset->Open(_bstr_t(sqlstr),_variant_t((IDispatch*)theApp.m_Connection,true),adOpenStatic,adLockOptimistic,adCmdText);
这段查询不了
sqlstr+="ins.fbillno,ins.fdate ,inss.frkqty,inss.fbatchno,u.name,inss.frow from ";
sqlstr+=DataBase+".t_supplier sup,"+DataBase+".t_user u,"+DataBase+".tic_instock1 ins,";
sqlstr+=DataBase+"tic_instock1items inss,"+DataBase+".tic_compare cp where pinv.fid=";
sqlstr+="cp.fproinvoiceid and prinvc.frow=cp.fproinvoicechildid and ins.fid=cp.finstockid ";
sqlstr+="and inss.frow=cp.finstockchildid and pro.finterid=prinv.fhth and sup.finterid=";
sqlstr+="prinv.fsupplierid";
m_recordset->Open(_bstr_t(sqlstr),_variant_t((IDispatch*)theApp.m_Connection,true),adOpenStatic,adLockOptimistic,adCmdText);
这段查询不了
