W
wyismail
Unregistered / Unconfirmed
GUEST, unregistred user!
CMeetReseanStr:= ' select count(*) as t from meettable m,eventproperty ep,eventreason er'+
' where m.reasoncode = er.reasoncode and m.eventprocode = ep.eventprocode'+
' and ep.name ='+#39+GRowname+#39+' and er.name ='+#39+GLinename+#39+
' and m.catchtime >='+#39+FormatDateTime('YYYY-MM-DD', GStartDate)+#39+
' and m.catchtime <='+#39+FormatDateTime('YYYY-MM-DD', GEndDate)+#39 ;
1 GLineName:=TemParLine;GRowName:=TemParRow;
2 MeetArray[i,j]:= DoSelectParForI(CMeetReseanStr);
DoSelectParForI是动态创建了一个ADOQUERY然后返回一个整数,放到数组里面
可是 GLineName:=TemParLine;GRowName:=TemParRow; 并没其作用
其值为空
' select count(*) as t from meettable m,eventproperty ep,eventreason
er where m.reasoncode = er.reasoncode and m.eventprocode = ep.eventprocode
and ep.name ='' and er.name ='' and m.catchtime >='2002-12-01' and m.catchtime <='2002-12-31''
我知道只要把SQL字符串放在 GLineName:=TemParLine;GRowName:=TemParRow;后边
就可以了,可是我的SQL太多了没办法啊