SQL syntax help please

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

 

[Stefan Hoffmann]

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& """"

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

 

[MikeR]

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

Maybe "SET [Selected] = True " & _ (missing closing quote).

Mike

 

[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!!

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&
""""

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

 

[Stefan Hoffmann]

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

Just enter a " in your txtTerritory before executing your code. Test it...

mfG
--> stefan <--

 

[De Jager]

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

 

[joelgeraldine]

kjkjkjk