批量执行长SQL语句问题

[bhzln]

我有一批update的sql语句要执行，但是在命令框里面执行，好像是因为过长，提示什么谓词错误，在运行里面执行，也不让执行，我要对VF表进行批量更新数据操作，请问大家如何操作

[YuyuanJian]

贴出来啊,这个很容易解决的!

[bhzln]

update KPBSJ set SJTZ1 = 0,SJTZ = 0,QZWSZZ1 = 0,QZWSZZ = 0,QZWSLR1 = 0,QZWSLR = 0,QZXJ1 = 0,QZXJ = 0,QZSW1 = 0,QZSW = 0,QZWSWXZC1 = 0,QZWSWXZC = 0,QZWSGYCQ1 = 0,QZWSGYCQ = 0,WSGDJK1 = 0,WSGDJK = 0,ZFTZ1 = 0,ZFTZ = 0,QZZFZZ1 = 0,QZZFZZ = 0,QZZFLR1 = 0,QZZFLR = 0,QZZFXJ1 = 0,QZZFXJ = 0,QZZFSW1 = 0,QZZFSW = 0,QZZFZCZJ1 = 0,QZZFZCZJ = 0,QZZFWXZC1 = 0,QZZFWXZC = 0,QZZFGYCQ1 = 0,QZZFGYCQ = 0,QZZFTDQ1 = 0,QZZFTDQ = 0,QT1 = 0,QT = 0,JKTZ1 = 0,JKTZ = 0,CYRY1 = 458,CYRY = 458,CYRYWF1 = 4,CYRYWF = 4,GZZE1 = 190,GZZE = 908,GZZEWF1 = 5,GZZEWF = 22,ZCZ1 = 1388,ZCZ = 8526,ZYSR1 = 1061,ZYSR = 11264,ZYCB1 = 780,ZYCB = 9007,SJSJ1 = 375,SJSJ = 820,QZZZS1 = 357,QZZZS = 615,QZJCKS1 = 0,QZJCKS = 0,QZQYS1 = 0,QZQYS = 51,LRZE1 = 78,LRZE = 1332,JLR1 = 78,JLR = 1281,FPLR1 = 0,FPLR = 0,QZWFLR1 = 0,QZWFLR = 0,QZHCLR1 = 0,QZHCLR = 0,ZCZE1 = 32774,ZCZE = 32774,QZGDZC1 = 10903,QZGDZC = 10903,QZLDZC1 = 18864,QZLDZC = 18864,QZWXZC1 = 3007,QZWXZC = 3007,FZZE1 = 11131,FZZE = 11131,QZLDFZ1 = 11131,QZLDFZ = 11131,QZCQFZ1 = 0,QZCQFZ = 0,SJCK1 = 0,SJCK = 48,SJJK1 = 0,SJJK = 0 where qydm = '2102604868265' 象这样的怎么拆分

[十豆三]

1、如果你是此语句送入数据源中：

lcString1="update KPBSJ set SJTZ1=0,SJTZ=0,QZWSZZ1=0,QZWSZZ=0,QZWSLR1=0,QZWSLR=0,QZXJ1=0,QZXJ=0,QZSW1=0,QZSW=0,QZWSWXZC1=0,QZWSWXZC=0,QZWSGYCQ1=0,QZWSGYCQ=0,WSGDJK1=0,WSGDJK=0,ZFTZ1=0,ZFTZ=0,QZZFZZ1=0,QZZFZZ=0,QZZFLR1=0,QZZFLR=0,QZZFXJ1=0,QZZFXJ=0,"
lcString2="QZZFSW1=0,QZZFSW=0,QZZFZCZJ1=0,QZZFZCZJ=0,QZZFWXZC1=0,QZZFWXZC=0,QZZFGYCQ1=0,QZZFGYCQ=0,QZZFTDQ1=0,QZZFTDQ=0,QT1=0,QT=0,JKTZ1=0,JKTZ=0,CYRY1=458,CYRY=458,CYRYWF1=4,CYRYWF=4,GZZE1=190,GZZE=908,GZZEWF1=5,GZZEWF=22,ZCZ1=1388,ZCZ=8526,"
lcString3="ZYSR1=1061,ZYSR=11264,ZYCB1=780,ZYCB=9007,SJSJ1=375,SJSJ=820,QZZZS1=357,QZZZS=615,QZJCKS1=0,QZJCKS=0,QZQYS1=0,QZQYS=51,LRZE1=78,LRZE=1332,JLR1=78,JLR=1281,FPLR1=0,FPLR=0,QZWFLR1=0,QZWFLR=0,QZHCLR1=0,QZHCLR=0,ZCZE1=32774,ZCZE=32774,"
lcString4="QZGDZC1=10903,QZGDZC =10903,QZLDZC1=18864,QZLDZC=18864,QZWXZC1=3007,QZWXZC=3007,FZZE1=11131,FZZE=11131,QZLDFZ1=11131,QZLDFZ=11131,QZCQFZ1=0,QZCQFZ=0,SJCK1=0,SJCK= 48,SJJK1=0,SJJK=0 where qydm='2102604868265'"

SQLEXEC(gnConnHandle,lcString1+lcString2+lcString3+lcString4)


2、如果你是对本地表进行操作：

lcString1="update KPBSJ set SJTZ1=0,SJTZ=0,QZWSZZ1=0,QZWSZZ=0,QZWSLR1=0,QZWSLR=0,QZXJ1=0,QZXJ=0,QZSW1=0,QZSW=0,QZWSWXZC1=0,QZWSWXZC=0,QZWSGYCQ1=0,QZWSGYCQ=0,WSGDJK1=0,WSGDJK=0,ZFTZ1=0,ZFTZ=0,QZZFZZ1=0,QZZFZZ=0,QZZFLR1=0,QZZFLR=0,QZZFXJ1=0,QZZFXJ=0,"
lcString2="QZZFSW1=0,QZZFSW=0,QZZFZCZJ1=0,QZZFZCZJ=0,QZZFWXZC1=0,QZZFWXZC=0,QZZFGYCQ1=0,QZZFGYCQ=0,QZZFTDQ1=0,QZZFTDQ=0,QT1=0,QT=0,JKTZ1=0,JKTZ=0,CYRY1=458,CYRY=458,CYRYWF1=4,CYRYWF=4,GZZE1=190,GZZE=908,GZZEWF1=5,GZZEWF=22,ZCZ1=1388,ZCZ=8526,"
lcString3="ZYSR1=1061,ZYSR=11264,ZYCB1=780,ZYCB=9007,SJSJ1=375,SJSJ=820,QZZZS1=357,QZZZS=615,QZJCKS1=0,QZJCKS=0,QZQYS1=0,QZQYS=51,LRZE1=78,LRZE=1332,JLR1=78,JLR=1281,FPLR1=0,FPLR=0,QZWFLR1=0,QZWFLR=0,QZHCLR1=0,QZHCLR=0,ZCZE1=32774,ZCZE=32774,"
lcString4="QZGDZC1=10903,QZGDZC =10903,QZLDZC1=18864,QZLDZC=18864,QZWXZC1=3007,QZWXZC=3007,FZZE1=11131,FZZE=11131,QZLDFZ1=11131,QZLDFZ=11131,QZCQFZ1=0,QZCQFZ=0,SJCK1=0,SJCK= 48,SJJK1=0,SJJK=0 where qydm='2102604868265'"

lcString0=lcString1+lcString2+lcString3+lcString4
&lcString0

[十豆三]

上面排版不太明显。

1、如果你是此语句送入数据源中：

lcString1="update KPBSJ set SJTZ1=0,SJTZ=0,QZWSZZ1=0,QZWSZZ=0,QZWSLR1=0,QZWSLR=0,QZXJ1=0,QZXJ=0,QZSW1=0,QZSW=0,QZWSWXZC1=0,QZWSWXZC=0,QZWSGYCQ1=0,QZWSGYCQ=0,WSGDJK1=0,WSGDJK=0,ZFTZ1=0,ZFTZ=0,QZZFZZ1=0,QZZFZZ=0,QZZFLR1=0,QZZFLR=0,QZZFXJ1=0,QZZFXJ=0,"

lcString2="QZZFSW1=0,QZZFSW=0,QZZFZCZJ1=0,QZZFZCZJ=0,QZZFWXZC1=0,QZZFWXZC=0,QZZFGYCQ1=0,QZZFGYCQ=0,QZZFTDQ1=0,QZZFTDQ=0,QT1=0,QT=0,JKTZ1=0,JKTZ=0,CYRY1=458,CYRY=458,CYRYWF1=4,CYRYWF=4,GZZE1=190,GZZE=908,GZZEWF1=5,GZZEWF=22,ZCZ1=1388,ZCZ=8526,"

lcString3="ZYSR1=1061,ZYSR=11264,ZYCB1=780,ZYCB=9007,SJSJ1=375,SJSJ=820,QZZZS1=357,QZZZS=615,QZJCKS1=0,QZJCKS=0,QZQYS1=0,QZQYS=51,LRZE1=78,LRZE=1332,JLR1=78,JLR=1281,FPLR1=0,FPLR=0,QZWFLR1=0,QZWFLR=0,QZHCLR1=0,QZHCLR=0,ZCZE1=32774,ZCZE=32774,"

lcString4="QZGDZC1=10903,QZGDZC =10903,QZLDZC1=18864,QZLDZC=18864,QZWXZC1=3007,QZWXZC=3007,FZZE1=11131,FZZE=11131,QZLDFZ1=11131,QZLDFZ=11131,QZCQFZ1=0,QZCQFZ=0,SJCK1=0,SJCK= 48,SJJK1=0,SJJK=0 where qydm='2102604868265'"

SQLEXEC(gnConnHandle,lcString1+lcString2+lcString3+lcString4)


2、如果你是对本地表进行操作：

lcString1="update KPBSJ set SJTZ1=0,SJTZ=0,QZWSZZ1=0,QZWSZZ=0,QZWSLR1=0,QZWSLR=0,QZXJ1=0,QZXJ=0,QZSW1=0,QZSW=0,QZWSWXZC1=0,QZWSWXZC=0,QZWSGYCQ1=0,QZWSGYCQ=0,WSGDJK1=0,WSGDJK=0,ZFTZ1=0,ZFTZ=0,QZZFZZ1=0,QZZFZZ=0,QZZFLR1=0,QZZFLR=0,QZZFXJ1=0,QZZFXJ=0,"

lcString2="QZZFSW1=0,QZZFSW=0,QZZFZCZJ1=0,QZZFZCZJ=0,QZZFWXZC1=0,QZZFWXZC=0,QZZFGYCQ1=0,QZZFGYCQ=0,QZZFTDQ1=0,QZZFTDQ=0,QT1=0,QT=0,JKTZ1=0,JKTZ=0,CYRY1=458,CYRY=458,CYRYWF1=4,CYRYWF=4,GZZE1=190,GZZE=908,GZZEWF1=5,GZZEWF=22,ZCZ1=1388,ZCZ=8526,"

lcString3="ZYSR1=1061,ZYSR=11264,ZYCB1=780,ZYCB=9007,SJSJ1=375,SJSJ=820,QZZZS1=357,QZZZS=615,QZJCKS1=0,QZJCKS=0,QZQYS1=0,QZQYS=51,LRZE1=78,LRZE=1332,JLR1=78,JLR=1281,FPLR1=0,FPLR=0,QZWFLR1=0,QZWFLR=0,QZHCLR1=0,QZHCLR=0,ZCZE1=32774,ZCZE=32774,"

lcString4="QZGDZC1=10903,QZGDZC =10903,QZLDZC1=18864,QZLDZC=18864,QZWXZC1=3007,QZWXZC=3007,FZZE1=11131,FZZE=11131,QZLDFZ1=11131,QZLDFZ=11131,QZCQFZ1=0,QZCQFZ=0,SJCK1=0,SJCK= 48,SJJK1=0,SJJK=0 where qydm='2102604868265'"

lcString0=lcString1+lcString2+lcString3+lcString4
&lcString0

[aabiao]

VFP一句的长度限制是8K,上面的肯定还不是太长。用续行就可以了。

[十豆三]

把长度大于255的字符串拆分为长度小于255的多个字符串即可。