SQL statement in VBA

[Stanley]

I have a very long SQL statment that I am coding in VBA. I can't fit it on a
line. Is there any way I can extext it? I used the _ character to no avail.
Thanks,
Stan

 

[fredg]

I have a very long SQL statment that I am coding in VBA. I can't fit it on a
line. Is there any way I can extext it? I used the _ character to no avail.
Thanks,
Stan

You need to use the space and _ characters ( _) together....

"Select tblName.FieldA, tblName.FieldB" _
& " From tblName ... etc.... "

 

[chris.nebinger]

I usually do the following:

Dim SQL as String

SQL = "Select Field1, Field2, Field3 "
SQL = SQL & " FROM Table "
SQL = SQL & " INNER JOIN Table2 on Table1.field = Table2.Field "
SQL = SQL & " WHERE Field1=True "


Something like that...

Chris

 

[John W. Vinson]

I have a very long SQL statment that I am coding in VBA. I can't fit it on a
line. Is there any way I can extext it? I used the _ character to no avail.
Thanks,
Stan

Two things: you should not try to split a quote-delimited string across
multiple lines; and the continuation flag is not "_" but " _" - a space
followed by an underscore. Try something like

Dim strSQL As String
strSQL = "SELECT this, that, theother" _
& " FROM tablename" _
& " WHERE this = 1223 AND That = 'XYX'" _
& <etc etc>

Note that you're using & to concatenate text strings together, and that those
text strings should contain the necessary blanks; I'm using " WHERE in order
to prevent the resulting SQL string from containing

tablenameWHERE

all run together.

 

[Stuart McCall]

I have a very long SQL statment that I am coding in VBA. I can't fit it on
a
line. Is there any way I can extext it? I used the _ character to no
avail.
Thanks,
Stan

You could try my add-in which allows you to construct the SQL using the
query designer, then outputs it formatted for VBA. Hope it helps.

http://www.smccall.demon.co.uk/Downloads.htm#SQLFormat