' Sqlstr = "Select * From table Where PlanMainId ='" & Trim(Lab_BillId.Caption) & "' Order by MNumber_C"
上面这条语句可以执行的。
但下面这个我就是只想把几个字段列出来。
Sqlstr = "SELECT DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C, DemandDate, MName_C, Model_C" & _
"FROM Table where PlanMainId='" & Trim(Lab_BillId.Caption) & "' & _
Gourp by DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C," & _
"DemandDate, MName_C, Model_C"
执行的时候就会出现 列名DeptName无效, 我也试过把这个字段删去了,执行的时候就会出现列名DepDemandMainID无效,再删的话他就会依次的出现列名无效。请问这个是怎么原因吖。。请高手帮帮小弟.
上面这条语句可以执行的。
但下面这个我就是只想把几个字段列出来。
Sqlstr = "SELECT DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C, DemandDate, MName_C, Model_C" & _
"FROM Table where PlanMainId='" & Trim(Lab_BillId.Caption) & "' & _
Gourp by DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C," & _
"DemandDate, MName_C, Model_C"
执行的时候就会出现 列名DeptName无效, 我也试过把这个字段删去了,执行的时候就会出现列名DepDemandMainID无效,再删的话他就会依次的出现列名无效。请问这个是怎么原因吖。。请高手帮帮小弟.
解决方案 »
- vsgFlexGrid.Cell(flexcpChecked, PintRow, 3) = flexUnchecked问题?
- 如何把SELECT COUNT两句合并起来
- 想自己制作一个combobox遇到的问题
- VB6 如何读取程序根目录下指定文件夹中的图片 到程序的Image控件中?
- 高手们帮帮忙,vb如何用ADO调用SQL2000中的视图?
- vb与ole控件
- 新手求助,程序界面问题
- 请大家帮忙给解决个问题!
- 300分三个问题:如何取得一个文件夹下所有文件夹和文件的名称,大小,日期,小图标,大图标?
- activereport 支持在用激光打印机的时候打印不正确,为什么
- 如何实现文件夹重命名
- 如何把日期时间字符串转换成日期型变量,如何比较两个日期时间型变量的大小???急急急,等等等!!!!
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C, DemandDate, MName_C, Model_C" & _
"FROM Table where PlanMainId='" & Trim(Lab_BillId.Caption) & "' & _
Gourp by DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C," & _
"DemandDate, MName_C, Model_C" 试试!
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C, DemandDate, MName_C, Model_C" & _
"FROM Table where PlanMainId='" & Trim(Lab_BillId.Caption) & "' & _
Gourp by DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C," & _
"DemandDate, MName_C, Model_C"
不行的。。还是老样子
"DepDemandSubID, MNumber_C,Sum(DemandNumber) as DemandNumber_C, DemandDate, MName_C, Model_C" & _
"FROM Table where PlanMainId='" & Trim(Lab_BillId.Caption) & "' & _
Group by DeptName, DepDemandMainID,MNumber," & _
"DepDemandSubID, MNumber_C," & _
"DemandDate, MName_C, Model_C" 在GROUP BY子句里,去掉那个SUM。你说还不行,就真搞不懂了,我只能怀疑,你这个GROUP拼写错了!!!!