你上面的好多的字符串连接都没有用 "+" 加号连接啊! 就下面的一条语句来说.---这样写是错误的
'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='@RegCode' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq'---改成这样
'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='+@RegCode+' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq'
'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='@RegCode' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq'---改成这样
'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='+@RegCode+' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq'
----这样写是错误的 SQL code'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='@RegCode' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq'---改成这样 SQL code'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='''+@RegCode+''' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq'
我尝试一下哈,看看有什么问题,多谢多谢~~~
SourceType=dbf;SourceDB=Z:\ds\dj',
'select count(qybm) as listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from sdky where qybm='@RegCode
' group by qybm,qymc,ksh,qyhy,qyjj,qymc,swdjh,nsbj,debj,swfzrq')
declare @RegCode varchar(10)
set @RegCode='123'
select listcount,qybm,qymc,ksh,qyhy,qyjj,swdjh,nsbj,debj,swfzrq from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=dbf;SourceDB=Z:\ds\dj',sdky)
where qybm=@RegCode楼主语法错误的原因:
openrowset 规定 query字符串只能是常量,不能是变量!见帮助手册
来得晚了几秒钟。。我正在结贴你就发了帖子。
抱歉哈
不过还是要感谢你的帮助~~~!!!
SUTTER兄的是正解~~~!!!!