vb6.0 代码太长如何分二行

[wjfxyj]

我用vb调用sql 2000存储过程
代码太长，如何分二行或三行
sjsrGrade.rsDK1 "declare @id int,@lp varchar(3),@ch varchar(7),@zrcy decimal(4, 1),@zh1 varchar(8),@jrjy1 decimal(4, 1),@xbly1 decimal(4, 1),@gl1 decimal(5, 0),@yu1 decimal(3, 0),@jc1 decimal(4, 1),@zh2 varchar (8),@jrjy2 decimal(4, 1),@xbly2 decimal(4, 1),@gl2 decimal(3, 0),@yu2 decimal(3, 0),@jc2 decimal(4, 1),@zh3 varchar(8),@jrjy3 decimal(4, 1),@xbly3 decimal(4, 1),@gl3 decimal(3, 0),@yu3 decimal(3, 0),@jc3 decimal(4, 1),@jrcy decimal(4, 1),@xb varchar(3),@rgl numeric(18, 0),@ryu numeric(18, 1),@rdh numeric(18, 2),@xrq smalldatetime,@jcmc varchar(10),@lxmc varchar(20),@cx varchar(6),@xl varchar(6) set @id='" & id & "' set @lp='" & lp & "' set @ch='" & ch & "' set @zrcy='" & zrcy & "' set @zh1='" & zh1 & "' set @jrjy1='" & jrjy1 & "' set @xbly1='" & xbly1 & "' set @gl1='" & gl1 & "' set @yu1='" & yu1 & "'set @jc1='" & jc1 & "' set @zh2='" & zh2 & "' set @jrjy2='" & jrjy2 & "' set @xbly2='" & xbly2 "' set @gl2='" & gl2 & "' set @yu2='" & yu2 & "' set @jc2='" & jc2 & "' set @zh3='" & zh3 & "' set @jrjy3='" & jrjy3 & "' set @xbly3='" & xbly3 & "' set @gl3='" & gl3 & "' set @yu3='" & yu3 & "' set @jc3='" & jc3 & "' set @jrcy='" & jrcy & "' set @xb='" & xb & "' set @rgl='" & rgl & "' set @ryu='" & ryu & "' set @rdh='" & rdh & "' set @xrq='" & xrq & "' set @jcmc='" & jcmc & "' set @lxmc='" & lxmc & "' set @cx='" & cx & "' set @lx='" & lx & "' set @TableName='" & jbm & "' exec mod_sjsr @id,@lp,@ch,@zrcy,@zh1,@jrjy1,@xbly1,@gl1,@yu1,@jc1,@zh2,@jrjy2,@xbly2,@gl2,@yu2,@jc2,@zh3,@jrjy3,@xbly3,@gl3,@yu3,@jc3,@jrcy,@xb,@rgl,@ryu,@rdh,@xrq ,@jcmc,@lxmc,@cx ,@xl ,@TableName"

[贝隆]

& 可以凭借字符串
_ 可以换行

strP="123" & "456" & _
"789"

[wjfxyj]

不行啊，

[worldy]

s="abc ....................................." & _
"efg............................................." & _
"ijk.........."

注意 &和_之间要有空格

[wjfxyj]

1楼的语句能行
但换成我的语句不行

[wjfxyj]

我的代码漏掉一个符号，现在行了。
结贴，给分。