sql query

[orelv4]

hi ,
I have a sql in my code and it doesnt work...
does enyone see any problem with my sql?

strSQL = "SELECT prog_ID FROM Program WHERE Address = ' " & iaddress & " ' "

iaddress is a variable
thanks!!!

 

[boblarson]

What's the rest of the code that is using it. When you say "it doesn't work" what do you mean? Does it give an error, does it do anything? How are you using strSQL? Are you opening it with a Recordset, a DLookup, What?

 

[tranchemontaigne]

looks like you are missing the closing semicolin in your SQL Statement
________
Crime Insurance Dicussion

 

[namliam]

Yes lots of missing info and conjecture...

But geuswork...
' " & iaddress & " ' "
Note the extra spaces there....
Try:
'" & iaddress & "'"

 

[orelv4]

you right!!!
just the spaces.
thanks!!!!...

 

[c_smithwick]

looks like you are missing the closing semicolin in your SQL Statement

FYI. The closing semicolon is NOT required

 

[boblarson]

FYI. The closing semicolon is NOT required

Good point. That crossed my mind too as I don't ever use it in my code (it might exist in someone elses and I just leave it there when editing, but I don't include it myself).