DIVIDIR A LINHA DE COMANDO
como divido essa linha? pois tenho que colocar mais coisas e náo cabe na linha:
Conect.Execute ("update tabx set x1 = " & xx1 & ",x2 = " & xx2 & ", x3 = " & xx3 & ",x4 = " & xx4 & ",x5 = " & xx5 & ",x6 = " & xx6 & ",x7 = " & xx7 & ",x8 = " & xx8 & ",x9 = " & xx9 & ",x10 = " & xx10 & ",x11 = " & xx11 & ",x12 = " & xx12 & ", x13 = " & xx13 & ",x14 = " & xx14 & ",x15 = " & xx15 & ",x16 = " & xx16 & ",x17 = " & xx17 & ",x18 = " & xx18 & ",x19 = " & xx19 & ",x20 = " & xx20 & ",y1 = " & yy1 & ",y2 = " & yy2 & ",y3 = " & yy3 & ",y4 = " & yy4 & ",y5 = " & yy5 & ",y6 = " & yy6 & ",y7 = " & yy7 & ",y8 = " & yy8 & ",y9 = " & yy9 & ",y10 = " & yy10 & ",y11 = " & yy11 & ", c1='" & cc1 & "', c2='" & cc2 & "', c3='" & cc3 & "', c4='" & cc4 & "', c5='" & cc5 & "', c6='" & cc6 & "', c7='" & cc7 & "', c8='" & cc8 & "', c9='" & cc9 & "', c10='" & cc10 & "', c11='" & cc11 & "', c12='" & cc12 & "', c13='" & cc13 & "', c14='" & cc14 & "', c15='" & cc15 & "', c16='" & cc16 & "', c17='" & cc17 & "', c18='" & cc18 & "', c19='" & cc19 & "', c20='" & cc20 & "'")
Conect.Execute ("update tabx set x1 = " & xx1 & ",x2 = " & xx2 & ", x3 = " & xx3 & ",x4 = " & xx4 & ",x5 = " & xx5 & ",x6 = " & xx6 & ",x7 = " & xx7 & ",x8 = " & xx8 & ",x9 = " & xx9 & ",x10 = " & xx10 & ",x11 = " & xx11 & ",x12 = " & xx12 & ", x13 = " & xx13 & ",x14 = " & xx14 & ",x15 = " & xx15 & ",x16 = " & xx16 & ",x17 = " & xx17 & ",x18 = " & xx18 & ",x19 = " & xx19 & ",x20 = " & xx20 & ",y1 = " & yy1 & ",y2 = " & yy2 & ",y3 = " & yy3 & ",y4 = " & yy4 & ",y5 = " & yy5 & ",y6 = " & yy6 & ",y7 = " & yy7 & ",y8 = " & yy8 & ",y9 = " & yy9 & ",y10 = " & yy10 & ",y11 = " & yy11 & ", c1='" & cc1 & "', c2='" & cc2 & "', c3='" & cc3 & "', c4='" & cc4 & "', c5='" & cc5 & "', c6='" & cc6 & "', c7='" & cc7 & "', c8='" & cc8 & "', c9='" & cc9 & "', c10='" & cc10 & "', c11='" & cc11 & "', c12='" & cc12 & "', c13='" & cc13 & "', c14='" & cc14 & "', c15='" & cc15 & "', c16='" & cc16 & "', c17='" & cc17 & "', c18='" & cc18 & "', c19='" & cc19 & "', c20='" & cc20 & "'")
Use o _
Conect.Execute ("Update _
tabx set x1 _
etc...
Conect.Execute ("Update _
tabx set x1 _
etc...
Conect.Execute ("update tabx set x1 = " & xx1 & ",x2 = " & xx2 & ", x3 = " & xx3 _
& ",x4 = " & xx4 & ",x5 = " & xx5 & ",x6 = " & xx6 & ",x7 = " & xx7 & ",x8 = " & xx8 _
& ",x9 = " & xx9 & ",x10 = " & xx10 & ",x11 = " & xx11 & ",x12 = " & xx12 & ", x13 = " & xx13 _
& ",x14 = " & xx14 & ",x15 = " & xx15 & ",x16 = " & xx16 & ",x17 = " & xx17 & ",x18 = " & xx18 _
& ",x19 = " & xx19 & ",x20 = " & xx20 & ",y1 = " & yy1 & ",y2 = " & yy2 & ",y3 = " & yy3 _
& ",y4 = " & yy4 & ",y5 = " & yy5 & ",y6 = " & yy6 & ",y7 = " & yy7 & ",y8 = " & yy8 & _
",y9 = " & yy9 & ",y10 = " & yy10 & ",y11 = " & yy11 & ", c1='" & cc1 & "', c2='" & cc2 _
& "', c3='" & cc3 & "', c4='" & cc4 & "', c5='" & cc5 & "', c6='" & cc6 & "', c7='" & cc7 & _
"', c8='" & cc8 & "', c9='" & cc9 & "', c10='" & cc10 & "', c11='" & cc11 & "', c12='" & cc12 & _
"', c13='" & cc13 & "', c14='" & cc14 & "', c15='" & cc15 & "', c16='" & cc16 & "', c17='" & cc17 _
& "', c18='" & cc18 & "', c19='" & cc19 & "', c20='" & cc20 & "'")
& ",x4 = " & xx4 & ",x5 = " & xx5 & ",x6 = " & xx6 & ",x7 = " & xx7 & ",x8 = " & xx8 _
& ",x9 = " & xx9 & ",x10 = " & xx10 & ",x11 = " & xx11 & ",x12 = " & xx12 & ", x13 = " & xx13 _
& ",x14 = " & xx14 & ",x15 = " & xx15 & ",x16 = " & xx16 & ",x17 = " & xx17 & ",x18 = " & xx18 _
& ",x19 = " & xx19 & ",x20 = " & xx20 & ",y1 = " & yy1 & ",y2 = " & yy2 & ",y3 = " & yy3 _
& ",y4 = " & yy4 & ",y5 = " & yy5 & ",y6 = " & yy6 & ",y7 = " & yy7 & ",y8 = " & yy8 & _
",y9 = " & yy9 & ",y10 = " & yy10 & ",y11 = " & yy11 & ", c1='" & cc1 & "', c2='" & cc2 _
& "', c3='" & cc3 & "', c4='" & cc4 & "', c5='" & cc5 & "', c6='" & cc6 & "', c7='" & cc7 & _
"', c8='" & cc8 & "', c9='" & cc9 & "', c10='" & cc10 & "', c11='" & cc11 & "', c12='" & cc12 & _
"', c13='" & cc13 & "', c14='" & cc14 & "', c15='" & cc15 & "', c16='" & cc16 & "', c17='" & cc17 _
& "', c18='" & cc18 & "', c19='" & cc19 & "', c20='" & cc20 & "'")
Tópico encerrado , respostas não são mais permitidas