|
本帖最后由 peterpu 于 2020-1-12 23:04 编辑
目的:向数据库最后行插入“Sj.Fields("五分钟").Value = 888” 数据,程序“正确”正常运行(第一句Sql=);但程序“错误”无法正常运行(第二句Sql=);
不知道是否是SQL语句的复杂程度不同造成的?(不同部分用红色标注)
Sql = "SELECT lc1.日期,lc1.收盘,lc1.五分钟 FROM lc1 WHERE lc1.时间=1500 AND lc1.日期>= #" & Sheet5.Range("F13") & "# AND lc1.日期<= #" & Sheet5.Range("G13") & "# ORDER BY lc1.日期 asc" (正常运行程序)
Sql = "SELECT lc1.日期, lc1.收盘,lc1.五分钟,Round([量能],0) AS New量能, 振幅之平均值, 交量之合计,主控之合计 FROM lc1 INNER JOIN (SELECT lc1.日期, Sum(lc1.交量) AS 交量之合计, Avg(lc1.振幅) AS 振幅之平均值, Sum(lc1.主控) AS 主控之合计 FROM lc1 GROUP BY lc1.日期) AS T ON lc1.日期 = T.日期 WHERE lc1.时间=1500 AND lc1.日期>= #" & Sheet5.Range("F13") & "# AND lc1.日期<= #" & Sheet5.Range("G13") & "# ORDER BY lc1.日期 asc" (无法正常运行)
谢谢您的帮助!
具体资料.rar
|
|