我先在ACCESS数据库里调试好了下面的SQL语句,但是放进VB里执行到它是却报错
SELECT [order].[date] AS 时间,
[order].[orderID] AS 定单号,
[order].[breedID] AS 品种,
[order].[amount] AS 数量,
[callback].[reclaim_date] AS 反还时间,
[callback].[amount] AS 反还数量,
([order].[amount]-[callback].[amount])/[order].[amount] AS 损失率
FROM [order] LEFT JOIN callback ON ([order].[breedID]=[callback].[breedID])
AND ([order].[orderID]=[callback].[orderID])
WHERE [order].[customerID]='JLFDIA';
放进VB里是这样的:
rs.Open "SELECT [order].[date] AS 时间, " & _
"[order].[orderID] AS 定单号," & _
"[order].[breedID] AS 品种," & _
"[order].[amount] AS 数量," & _
"[callback].[reclaim_date] as 反还时间," & _
"[callback].[amount] AS 反还数量," & _
"([order].[amount]-[callback].[amount])/[order].[amount] AS 损失率" & _
"FROM [order] LEFT JOIN callback ON ([order].[orderID]=[callback].[orderID])" & _
"AND ([order].[breedID]=[callback].[breedID])" & _
"where [order].[customerID]='JLFDIA';", con, adOpenStatic, adLockPessimistic
SELECT [order].[date] AS 时间,
[order].[orderID] AS 定单号,
[order].[breedID] AS 品种,
[order].[amount] AS 数量,
[callback].[reclaim_date] AS 反还时间,
[callback].[amount] AS 反还数量,
([order].[amount]-[callback].[amount])/[order].[amount] AS 损失率
FROM [order] LEFT JOIN callback ON ([order].[breedID]=[callback].[breedID])
AND ([order].[orderID]=[callback].[orderID])
WHERE [order].[customerID]='JLFDIA';
放进VB里是这样的:
rs.Open "SELECT [order].[date] AS 时间, " & _
"[order].[orderID] AS 定单号," & _
"[order].[breedID] AS 品种," & _
"[order].[amount] AS 数量," & _
"[callback].[reclaim_date] as 反还时间," & _
"[callback].[amount] AS 反还数量," & _
"([order].[amount]-[callback].[amount])/[order].[amount] AS 损失率" & _
"FROM [order] LEFT JOIN callback ON ([order].[orderID]=[callback].[orderID])" & _
"AND ([order].[breedID]=[callback].[breedID])" & _
"where [order].[customerID]='JLFDIA';", con, adOpenStatic, adLockPessimistic
解决方案 »
- 求:鼠标自动获取颜色点击器
- vb checkbox 复选框问题!!
- 如何让字符串全变成相同位数的。比如数据库表中为2-8位,但是取出来时想变成全是8位的,不足8位后补空格,就是为了整齐好看
- 如何使新建的Excel工作薄只含一个工作表
- 如何打印图形及表格,求解决方案
- 一个关于datagrid更新的问题,解决立即给分。
- 窗口方式问题
- 唉,烦。用Webbrowser控件打开一个Word文档时,总有一个询问打开、保存的对话框,怎么去掉?
- 请问哪里有farpoint tab pro 2.045 或其它2点几的版本下载
- VB WSADuplicateSocket 用法
- 急!请问怎么样获得设备的盘符?
- 如何实现IE自动填表 或文本拖放(给30分)
一、FROM前面没有空格。
二、LEFT JOIN后的AND前面没有空格。
三、WHERE前面没有空格。
"FROM [order] LEFT JOIN callback ON ([order].[orderID]=[callback].[
损失率 和 FROM 之间没有空格,在损失率和FROM之间加上一个空格即可