probs using line continuation characters

[MLH]

I don't understand why (a) works and compiles but (b) does not...

(a)
Set qdfTemp = .CreateQueryDef("", _
"SELECT * FROM Employees")

(b)
Set qdfTemp = .CreateQueryDef("", _
"SELECT DISTINCTROW tblPmtsRcd.PmtID,
tblPmtsRcd.InvoiceNumber, tblPmtsRcd.VehicleJobID,
tblPmtsRcd.PmtRecTDStamp _
FROM tblPmtsRcd LEFT JOIN tblinvoiceData ON
tblPmtsRcd.InvoiceNumber = tblinvoiceData.InvoiceNumber _
WHERE tblPmtsRcd.InvoiceNumber<>0 And tblPmtsRcd.InvoiceNumber
Is Not Null AND tblinvoiceData.InvoiceNumber Is Null")
' Open Recordset and print report.
GetrstTemp qdfTemp

Isn't (b) just a longer SQL string with continuation characters and
(a) a shorter SQL string with continuation characters?

Everytime I type the Set statement in (b) into a module, it turns
red and gives me an error. I do not recognize what is wrong.
With the damned newsreader wrapping - you may not be able
to see what I'm doing wrong either. Sorry about that. Would
like to know. If I type EVERYTHING on one line - no problem.
But when I try using line continuation characters everything
turns red.

[Arch]

On Thu, 01 May 2008 19:10:57 -0400, MLH <CR**@NorthState.netwrote:

>I don't understand why (a) works and compiles but (b) does not...

(a)
Set qdfTemp = .CreateQueryDef("", _
"SELECT * FROM Employees")

(b)
Set qdfTemp = .CreateQueryDef("", _
"SELECT DISTINCTROW tblPmtsRcd.PmtID,
tblPmtsRcd.InvoiceNumber, tblPmtsRcd.VehicleJobID,
tblPmtsRcd.PmtRecTDStamp _
FROM tblPmtsRcd LEFT JOIN tblinvoiceData ON
tblPmtsRcd.InvoiceNumber = tblinvoiceData.InvoiceNumber _
WHERE tblPmtsRcd.InvoiceNumber<>0 And tblPmtsRcd.InvoiceNumber
Is Not Null AND tblinvoiceData.InvoiceNumber Is Null")
' Open Recordset and print report.
GetrstTemp qdfTemp

Isn't (b) just a longer SQL string with continuation characters and
(a) a shorter SQL string with continuation characters?

Everytime I type the Set statement in (b) into a module, it turns
red and gives me an error. I do not recognize what is wrong.
With the damned newsreader wrapping - you may not be able
to see what I'm doing wrong either. Sorry about that. Would
like to know. If I type EVERYTHING on one line - no problem.
But when I try using line continuation characters everything
turns red.

In b, you have the continuation character in the middle of a literal
string (" on both ends), but not in a.

If you need to continue a literal string there are a couple of options

SQL = "First part of the string " & _
"continuation of string " & _
"last line of string"

SQL = "First part of the string " _
& "continuation of string " _
& "last line of string"

[MLH]

Are you sure I'm in the middle of a literal string?
I don't think that's the case.

>
In b, you have the continuation character in the middle of a literal
string (" on both ends), but not in a.

If you need to continue a literal string there are a couple of options

SQL = "First part of the string " & _
"continuation of string " & _
"last line of string"

SQL = "First part of the string " _
& "continuation of string " _
& "last line of string"

[MLH]

Oops. My bad. Sorry... now I see it.