向各位高手请教一个问题,很头疼的问题,我始终说不出原因
下面是程序的一段源码,目的是想查询出某段时间内借出的书本,并用列表框控件显示数据,其中时间可以随时设置,根据图书借阅时间来设置。查询语句我已经写在下面,但是运行是我发现,SQL的值不是我写的全部内容,而是在borrow.state 处就结束了,如此一来,这个语法系统当然会报错,但是我不明白系统会截断我的语句,请问这是什么错误呢,我已经不是第一次了,谢谢各位的指教。
Private Sub CmdQuery_Click()
Dim SQL As String
Dim SqlTimeFrom As Date
Dim SqlTimeTo As Date
SqlTimeFrom = DTPFrom.Value
SqlTimeTo = DTPTo.Value
SQL = "select borrow.bookid as 图书编号,borrow.bookname as 图书名称,borrow.borrowtime as 借书时间"
SQL = SQL + "borrow.readerid as 读者工号,reader.depart as 部门,reader.name as 读者姓名,borrow.type as 图书类别,"
SQL = SQL + "borrow.returntime as 还书时间,borrow.state as 借阅标志,borrow.overstate as 是否超期,"
SQL = SQL + "borrow.chaoqidays as 超期天数,books.price as 图书定价 from borrow,reader,books "
SQL = SQL + "where reader.id=borrow.readerid and borrow.bookid=books.bookid and borrow.state='在借' and (borrow.borrowtime between sqltimefrom and sqltimeto"
DataEnv.rssqlBorrQuery.Close
DataEnv.rssqlBorrQuery.Open SQL
''刷新用户导航的网格控件,并且根据记录集中记录的数目,来改变各个浏览按钮的状态。
Call RefreshGrid
End SubPrivate Sub RefreshGrid()
DGQuery.DataMember = ""
DGQuery.Refresh
DataEnv.rssqlBorrQuery.Requery DGQuery.DataMember = "sqlBorrQuery"
DGQuery.Refresh
End Sub
下面是程序的一段源码,目的是想查询出某段时间内借出的书本,并用列表框控件显示数据,其中时间可以随时设置,根据图书借阅时间来设置。查询语句我已经写在下面,但是运行是我发现,SQL的值不是我写的全部内容,而是在borrow.state 处就结束了,如此一来,这个语法系统当然会报错,但是我不明白系统会截断我的语句,请问这是什么错误呢,我已经不是第一次了,谢谢各位的指教。
Private Sub CmdQuery_Click()
Dim SQL As String
Dim SqlTimeFrom As Date
Dim SqlTimeTo As Date
SqlTimeFrom = DTPFrom.Value
SqlTimeTo = DTPTo.Value
SQL = "select borrow.bookid as 图书编号,borrow.bookname as 图书名称,borrow.borrowtime as 借书时间"
SQL = SQL + "borrow.readerid as 读者工号,reader.depart as 部门,reader.name as 读者姓名,borrow.type as 图书类别,"
SQL = SQL + "borrow.returntime as 还书时间,borrow.state as 借阅标志,borrow.overstate as 是否超期,"
SQL = SQL + "borrow.chaoqidays as 超期天数,books.price as 图书定价 from borrow,reader,books "
SQL = SQL + "where reader.id=borrow.readerid and borrow.bookid=books.bookid and borrow.state='在借' and (borrow.borrowtime between sqltimefrom and sqltimeto"
DataEnv.rssqlBorrQuery.Close
DataEnv.rssqlBorrQuery.Open SQL
''刷新用户导航的网格控件,并且根据记录集中记录的数目,来改变各个浏览按钮的状态。
Call RefreshGrid
End SubPrivate Sub RefreshGrid()
DGQuery.DataMember = ""
DGQuery.Refresh
DataEnv.rssqlBorrQuery.Requery DGQuery.DataMember = "sqlBorrQuery"
DGQuery.Refresh
End Sub
解决方案 »
- 如何用Excel的VBA切换到CAD程序?模拟ALT+TAB功能.
- 如何将十六进制表示的一个浮点数转化为single?
- 我在用group by 语句时提示“不能将已选定'*'的字段中组合”
- 急问,请高手帮忙阿
- 关于do...loop时,CPU占用100%的难题,高分求答!!
- 制作游戏修改器
- 用DAO连接Access数据库更新问题
- 大家进来看看..!!
- znull(随疯而来)我认为你关于MSFlexGrid问题讲的好,50分为你.希望我们作程序的多交流,来提高我们自身的水平.
- 再次求教关于TextBox的问题!急!!!
- 有什么办法能获得窗体最小化的事件
- 初始化提供者中发生错误,测试连接失败(初学者)
是不是'在借' 中的单引号将后面的语句注释掉了?应该不会的!
少个逗号,
另外你是用什么方法跟踪SQL的值的?
SQL = SQL + "borrow.readerid as 读者工号,reader.depart as 部门,reader.name as 读者姓名,borrow.type as 图书类别,"
SQL = SQL + "borrow.returntime as 还书时间,borrow.state as 借阅标志,borrow.overstate as 是否超期,"
SQL = SQL + "borrow.chaoqidays as 超期天数,books.price as 图书定价 from borrow,reader,books "
SQL = SQL + "where reader.id=borrow.readerid and borrow.bookid=books.bookid and borrow.state='在借' "
SQL=SQL+" and borrow.borrowtime between '" & sqltimefrom & "' and '" & sqltimeto & "'"