Dim ssq As String
Label11.Caption = "4"
a = "(select top " & Val(Label11.Caption) * 30 & " * from 查询结果显示表) a"
b = "(select top " & (Val(Label11.Caption) - 1) * 30 & " 品名范围 from 查询结果显示表) b"
ssq = "select * from " & a & "where 品名范围 not in " & b
Data3.RecordSource = ssq
Data3.Refresh
Label11.Caption = "4"
a = "(select top " & Val(Label11.Caption) * 30 & " * from 查询结果显示表) a"
b = "(select top " & (Val(Label11.Caption) - 1) * 30 & " 品名范围 from 查询结果显示表) b"
ssq = "select * from " & a & "where 品名范围 not in " & b
Data3.RecordSource = ssq
Data3.Refresh
解决方案 »
- VB6 如何 读取 ini 文件里某一键值里所有内容
- 如何取得WebBrowser里面的某个图片(如验证码)的内容或者如何复制这个验证码图片到PictureBox
- 有点急..查了好久资料了 在线等 ..望解答..
- 如何用VB编出来的程序打开记事本???
- 救命啊!!!!!!!!!!!!!!!!!
- 啥叫颜色的透明度?
- 请各位大哥请教Treeview控件的用法
- 如何穿透代理服务器发送Email
- 帮忙做一个关于远程改写注册表的程序(在线等待)急~~~~~~~~
- 有没有用过internet transfer control 6.0的?
- 《〈〈〈〈〈〈〈〈〈大家教教我 FlexGrid和 DBGrid的不同之处,他们那个功能更强大,更易用
- cool_fly(cool_fly) 麻烦你再给我发一下! 谢谢
a = "select top " & Val(Label11.Caption) * 30 & " * from 查询结果显示表 "
b = "(select top " & (Val(Label11.Caption) - 1) * 30 & " 品名范围 from 查询结果显示表) b"
ssq = a & "where 品名范围 not in " & b
b = "select top " & cstr((Val(Label11.Caption) - 1) * 30) & " * from 查询结果显示表"
Dim b As String
a = "select top " & CStr(Val(Label11.Caption) * 30) & "* from 查询结果显示表 "
b = "select top " & CStr((Val(Label11.Caption) - 1) * 30) & "* from 查询结果显示表 "
ssq = a & " where 品名范围 not in " & bData3.RecordSource = ssq
Data3.Refresh
提示:select字句中包含保留字,或者参数,或者标点符号不正确,哪里?我真的是找不到呀!
select top 60* from 查询结果显示表 where 品名范围 not in select top
30* from 查询结果显示表
语法错误,在查询表达式 ‘品名范围 not in select top 30 * from 查询结果显示表‘中。
b = "(select top " & str((Val(Label11.Caption)-1)*30) & " * from 查询结果显示表 order by 品名范围)"
ssq = "select * from " & a & "where 品名范围 not in " & b
a = "(select top " & str(Val(Label11.Caption)*30) & " * from 查询结果显示表) a"
b = "(select top " & str((Val(Label11.Caption)-1)*30) & " * from 查询结果显示表)"
ssq = "select * from " & a & "where 品名范围 not in " & b
a = "(select top " & str(Val(Label11.Caption)*30) & " * from 查询结果显示表) a"
b = "(select top " & str((Val(Label11.Caption)-1)*30) & " 品名范围 from 查询结果显示表)" ----这里要指定字段的,否则不对
ssq = "select * from " & a & "where 品名范围 not in " & b