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.
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.