22,209
社区成员
发帖
与我相关
我的任务
分享
for dqpagekhnum=0 to 9
htmpsql0=sqlp+" having khrijl.KHID='"&kidArray(0)&"' and khrijl.xsdate='"&gairixqj&"' "
Set rshtmpsql0=Conn.Execute(htmpsql0)
If rshtmpsql0.bof And rshtmpsql0.eof Then
khje0=0
else
khje0=rshtmpsql0("khje")
khje=khje&khje0
End If
Set rshtmpsql0 = Nothing
next
for dqpagekhnum=0 to 9
htmpsql0=sqlp+" having khrijl.KHID='"&kidArray(dqpagekhnum)&"' and khrijl.xsdate='"&gairixqj&"'
不懂,帮顶,学习,蹭分.
DECLARE @dqpagekhnum INT
SET @dqpagekhnum=0
WHILE @dqpagekhnum<=9
BEGIN
...
END
在 htmpsql0=sqlp+" having khrijl.KHID='"&kidArray(0)&"' and
khrijl.xsdate='"&gairixqj&"'" 的前面声明一个变量,用这个变量来存储由
kidArray(dqpagekhnum)计算得到的结果,然后再在 htmpsql0 中引用该变量试试...