一个很长的程序,没有耐心的毋进(送上300分,分批送) 用跟踪调试,不过从问题看,一般都是SQL语句中order by ,group by前后的语法出现问题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你没发现这句话有点问题吗?sql = "SELECT cust.*,io_del.*" sql = sql & "FROM io_del INNER JOIN cust ON io_del.cst_no=cust.cst_no" sql = sql & "ORDER BY io_del.csh_no Desc"少空格!!sql = "SELECT cust.*,io_del.*" sql = sql & " FROM io_del INNER JOIN cust ON io_del.cst_no=cust.cst_no" sql = sql & " ORDER BY io_del.csh_no Desc"应该可以了 下面一个sql字符串连接同样有这个问题建议你这样sql = "SELECT cust.*,io_del.*" _ & " FROM io_del INNER JOIN cust ON io_del.cst_no=cust.cst_no" _ & " ORDER BY io_del.csh_no Desc" Vb cls问题 初学者问一个程序 请求帮组 急急急 关于用Controls.Remove "picclass(i).pic1"动态删除 赚分帖~~~ dll重新编译,exe是否需要重新编译? 复选框的属性保持问题 忽略了数据库名称#name,将引用tempdb中的对象 请问vb、vc 做的com+组件,有何区别?? 怎样编写五子棋游戏 如何用DAO的方法判断数据库中是否存在某个表? 请教各位怎么才能读出Assecc数据库里的所有表名?急用的!请大家帮帮忙! 请高手回答吧!!!!
sql = "SELECT cust.*,io_del.*"
sql = sql & "FROM io_del INNER JOIN cust ON io_del.cst_no=cust.cst_no"
sql = sql & "ORDER BY io_del.csh_no Desc"
少空格!!
sql = "SELECT cust.*,io_del.*"
sql = sql & " FROM io_del INNER JOIN cust ON io_del.cst_no=cust.cst_no"
sql = sql & " ORDER BY io_del.csh_no Desc"
应该可以了
建议你这样
sql = "SELECT cust.*,io_del.*" _
& " FROM io_del INNER JOIN cust ON io_del.cst_no=cust.cst_no" _
& " ORDER BY io_del.csh_no Desc"