SQL syntax help please

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hi all

I had an update sql statement working setting a value to true (boolean
field) on a set condition, but I am now trying to update a 2nd field also
which is text type and I can't seem to get the syntax right. I get 'expected
end of statement' message. Code is:

strSQL = "UPDATE [qry Resource Planning VVs] " & _
"SET [Selected] = True & _
"[Activity] = '"VV"', " & _
"WHERE Territory_Code = " & """" & txtTerritory & """"

Can anyone please help correct this? Thanks...
 
hi Sue,

I get 'expected end of statement' message. Code is:

strSQL = "UPDATE [qry Resource Planning VVs] "& _
"SET [Selected] = True& _
"[Activity] = '"VV"', "& _
"WHERE Territory_Code = "& """"& txtTerritory& """"
Click to expand...
There is a comma missing and the quotation marks are also wrong:

strSQL = _
"UPDATE [qry Resource Planning VVs] " & _
"SET [Selected] = True, " & _
"[Activity] = 'VV' " & _
"WHERE [Territory_Code] = '" & Replace(txtTerritory, "'", "''") & "'"


mfG
--> stefan <--
 
Sue said:
Hi all

I had an update sql statement working setting a value to true (boolean
field) on a set condition, but I am now trying to update a 2nd field also
which is text type and I can't seem to get the syntax right. I get 'expected
end of statement' message. Code is:

strSQL = "UPDATE [qry Resource Planning VVs] " & _
"SET [Selected] = True & _
"[Activity] = '"VV"', " & _
"WHERE Territory_Code = " & """" & txtTerritory & """"

Can anyone please help correct this? Thanks...
Click to expand...
Maybe "SET [Selected] = True " & _ (missing closing quote).

Mike
 
Thanks Stefan that sorted it :-). I changed the quotes and added the comma.
I left the where clause alone though as this was working ok before. Thanks
again for the help!!


Stefan Hoffmann said:
hi Sue,

I get 'expected end of statement' message. Code is:

strSQL = "UPDATE [qry Resource Planning VVs] "& _
"SET [Selected] = True& _
"[Activity] = '"VV"', "& _
"WHERE Territory_Code = "& """"& txtTerritory&
""""
Click to expand...
There is a comma missing and the quotation marks are also wrong:

strSQL = _
"UPDATE [qry Resource Planning VVs] " & _
"SET [Selected] = True, " & _
"[Activity] = 'VV' " & _
"WHERE [Territory_Code] = '" & Replace(txtTerritory, "'", "''") & "'"


mfG
--> stefan <--
Click to expand...
 
hi Sue,

Thanks Stefan that sorted it :-). I changed the quotes and added the comma.
I left the where clause alone though as this was working ok before. Thanks
again for the help!!
Click to expand...
Just enter a " in your txtTerritory before executing your code. Test it...

mfG
--> stefan <--
 
Sue said:
Hi all

I had an update sql statement working setting a value to true (boolean
field) on a set condition, but I am now trying to update a 2nd field also
which is text type and I can't seem to get the syntax right. I get
'expected end of statement' message. Code is:

strSQL = "UPDATE [qry Resource Planning VVs] " & _
"SET [Selected] = True & _
"[Activity] = '"VV"', " & _
"WHERE Territory_Code = " & """" & txtTerritory & """"

Can anyone please help correct this? Thanks...
Click to expand...
 
Back
Top