急！怎么样使一行写不完的语句，能连接到下一行接着写不出错？用什么符号连接？？

Question

sql="dddddddddddddddddddddslf lsd l;sdfl lsfdl sldlfsdl lsdl flsdlf lsdl"
sql=sql & "d lksfj lksdfkl ioas jsdkf klsdkf jsjskld fjskld fjsdf"
sql=sql & " asd;lf jskrfklsdkjfklsfjklsdfjjsd kfdsklj dsf klds klsdjk fjksdlk klsdjf dkf jsjf"
sql=sql & "dsldf jlsjdf jsle rj flksdj fiowjifj lsdj oi"

Answer 1

先打一空格,然后打一个下划线(_),再回车折行就行了.
eg.
    lngResult = _
    GetSystemDirectory _
    (strSysPath, 255)
    

Answer 2

sql="dddddddddddddddddddddslf lsd l;sdfl lsfdl sldlfsdl lsdl flsdlf lsdl" & _
"d lksfj lksdfkl ioas jsdkf klsdkf jsjskld fjskld fjsdf" & _
"asd;lf jskrfklsdkjfklsfjklsdfjjsd kfdsklj dsf klds klsdjk fjksdlk & _ klsdjf dkf jsjf" & _
"dsldf jlsjdf jsle rj flksdj fiowjifj lsdj oi"用 & _

Answer 3

&是字符串连接符._才是续行符.小猫的写法是长字符串连接的一种情况,用他的写法试试长的语句,比如API声明,就不行了.

Answer 4

sql="aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"_
    "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb"

Answer 5

abfdsagsfd _
fdsakjgjklds _
fjkdsajfk _

Answer 6

或者这样    sql = "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" _
    & "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb"