rs11.Open "select bgdb.bgrq,bgdb.scbh,bgdb.bgdh,ckb.cpmc,ckb.cpsl,pbasic.pdw,ckb.dj,ckb.je,ckb.bz,ckb.fph from bgdb,ckb,pbasic where bgdb.bgdh = ckb.bgdh and ckb.cpmc = pbasic.pmc and bgdb.scbh in (select distinct bgdb.scbh from bgdb where bgdb.bgdh = '" & Trim(rs12.Fields(0)) & "')", cn, 3, 1我自己试了n次,发现好象是子查询的问题,但我不知道哪儿不对,谢谢各位!
解决方案 »
- 寻找vb在文本中插入一行数据最优的方法
- 请问:ActiveBar2.0在设置快捷键时总报错,为什么?
- 如何删除ListView控件中的特定行
- 我想将listview的东西拖到treeview,怎么实现?
- vb的前景?
- wdl是什么文件类型啊?
- VB初学者,请大家帮忙!!我想实现点击datagrid中的一行,使这一行的背景颜色与别的行有所区别,
- 请问各位大哥大姐,如何用代码拦截WINDOWS关机?有高分奉送。。。。
- 求 比尔盖茨的大幅面(800*600以上)照片的下载网址,最好是广告用的,谢谢!
- 910,为何我的贴子看不到了?就是"910请看"那片,进去什么也没有???
- 机器上安装了access2000,工程里引用了DAO3.6,是不是一定要打上sp5,才能用DATA控件绑定Access2000数据库文件??
- 请能帮帮我啊,100分全给了
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
' 引用 ODBC driver 建立连接.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=dcser;uid=sa;pwd=;database=stxt"
cnn.OpenadoConnection.Execute "Update Rs Set QQTS = 0" 请问这句要怎么改呢?
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
' 引用 ODBC driver 建立连接.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=dcser;uid=sa;pwd=;database=stxt"
cnn.OpenadoConnection.Execute "Update Rs Set QQTS = 0" 请问这句要怎么改呢?错误信息424 要求对象
这种表达多此一举
rs11.Open "select T1.bgrq,T1.scbh,T1.bgdh,T2.cpmc,T2.cpsl,T3.pdw,T2.dj,T2.je,T2.bz,T2.fph from bgdb T1,ckb T2,pbasic T3 where T1.bgdh = T2.bgdh and T2.cpmc = T3.pmc and T1.bgdh = '" & Trim(rs12.Fields(0)) & "'", cn, 3, 1
更希望
rs11.Open "select T1.bgrq,T1.scbh,T1.bgdh,T2.cpmc,T2.cpsl,T3.pdw,T2.dj,T2.je,T2.bz,T2.fph from bgdb T1 inner join (ckb T2 inner join pbasic T3 on T2.cpmc = T3.pmc) on T1.bgdh = T2.bgdh where T1.bgdh = '" & Trim(rs12.Fields(0)) & "'", cn, 3, 1
最后一句改为 cn.Execute "Update Rs Set QQTS = 0"
select distinct bgdb.scbh 这一句少不得的.
大家帮帮忙吧!谢谢了!
txtsql="select bgdb.bgrq,bgdb.scbh,bgdb.bgdh,ckb.cpmc,ckb.cpsl,pbasic.pdw,ckb.dj,ckb.je,ckb.bz,ckb.fph from bgdb,ckb,pbasic where bgdb.bgdh = ckb.bgdh and ckb.cpmc = pbasic.pmc and (bgdb.scbh in (select distinct bgdb.scbh from bgdb where bgdb.bgdh = '" &
Trim(rs12.Fields(0)) & "'))"
rsl1.open txtsql,cn,3,1
试一下,不知行不行
不妨先试子查询,通过后再试主查询。那里的错误提示比较具体。
不过,还是谢谢你热心帮我.
"select bgdb.bgrq,bgdb.scbh,bgdb.bgdh,ckb.cpmc,ckb.cpsl,pbasic.pdw,ckb.dj,ckb.je,ckb.bz,ckb.fph from bgdb inner join ckb on bgdb.bgdh = ckb.bgdh inner join pbasic on ckb.cpmc = pbasic.pmc where bgdb.scbh in (select distinct bgdb.scbh from bgdb where bgdb.bgdh = '" & Trim(rs12.Fields(0)) & "')"
rs11.Open "select bgdb.bgrq,bgdb.scbh,bgdb.bgdh,ckb.cpmc,ckb.cpsl,pbasic.pdw,ckb.dj,ckb.je,ckb.bz,ckb.fph from bgdb,ckb,pbasic where bgdb.bgdh = ckb.bgdh and ckb.cpmc = pbasic.pmc and bgdb.scbh in (select distinct bgdb.scbh from bgdb where bgdb.bgdh = '" & Trim(rs12.Fields(0)) & "')", cn, 3, 1你这语句中的语法并没错,但是你确定 bgdb.bgdh = ckb.bgdh and ckb.cpmc = pbasic.pmc 等子句中的字段类型是字符型、日期型、或返回值有空格等等情况吗?举例说:bgdb.bgdh = ckb.bgdh 中ckb.bgdh字段是字符或日期型或者ckb.bgdh的返回值中间有空格吗?如果是前两者,那么要加上单引号或#(即bgdb.bgdh = 'ckb.bgdh'或者bgdb.bgdh = #ckb.bgdh#),如果是后者,那么要加上两个中括号(即bgdb.bgdh = [ckb.bgdh]),另外为了避免出错最好所有的语句元素都加上中括号(当然中括号可以省略,但如果元素中间夹有空格时则不能省略,否则出错),这些只是我的建议,我刚学VB,很多不懂,还望各位大侠指教!!!