| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 365 人关注过本帖
标题:请大虾们帮帮忙啊!
只看楼主 加入收藏
人王
Rank: 2
等 级:论坛游民
帖 子:20
专家分:22
注 册:2011-7-2
结帖率:25%
收藏
已结贴  问题点数:20 回复次数:1 
请大虾们帮帮忙啊!
DLSQL = "SELECT Max([HY]) AS [HY],Min([LY]) AS [LY] FROM ("
DLSQL = DLSQL & " SELECT Max([EX-Time]) AS [HY],Min([EX-Time]) AS [LY] FROM [Expenditure]"
DLSQL = DLSQL & " Union SELECT Max([C-AcceptDate]) AS [HY],Min([C-AcceptDate]) AS [LY] FROM [CreditCard]"
DLSQL = DLSQL & " Union SELECT Max(A.[S-Date]) AS [HY],Min(A.[S-Date]) AS [LY] FROM [G-Title] AS A,(SELECT DISTINCT [G-Number] FROM [GroupMembers] WHERE ([D-Subscribe]+[D-Discount]+[D-RealMeney]+[D-Card]) > 0) AS B WHERE A.[G-Number] = B.[G-Number] "
DLSQL = DLSQL & ")"
我运行后出现下面的信息
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ')' 附近有语法错误。
数据库连接都是没错的。
大家看看哪里出错了啊,谢谢啦!!!
2012-03-31 10:31
E小韭
Rank: 2
等 级:论坛游民
帖 子:14
专家分:22
注 册:2012-3-20
收藏
得分:20 
从这错误来看,貌似就是连接不成功啊
2012-03-31 12:06
快速回复:请大虾们帮帮忙啊!
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.011706 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved