PDA

View Full Version : String Variable - Compile Error Expected End of Statment



paddysheeran
03-20-2012, 05:41 AM
HI All,

when declaring a string variable why would the following work fine:

Sub Query_SQL3()
Dim QSQL As String
QSQL = "Array(""SELECT TYS____FAULT.SEVERITY,TYS____FAULT.OLD_FAULT_ID"")"
End Sub

But the following produces the compile error stement:

Sub Query_SQL3()
Dim QSQL As String
QSQL = "Array(""SELECT TYS____FAULT.SEVERITY, _
TYS____FAULT.OLD_FAULT_ID"")"
End Sub

Im sure its something simple but cant put my finger on it.

thanks,

Paddy.

Bob Phillips
03-20-2012, 05:46 AM
Try this



Sub Query_SQL3()
Dim QSQL As String
QSQL = "Array(""SELECT TYS____FAULT.SEVERITY, " & _
"TYS____FAULT.OLD_FAULT_ID"")"
End Sub