0

i can't see where is the Invalid character with the SQL statement below. i can't see where i miss any character or i added extra characters.

mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & ", col4 = " & rD & ", col5 = " & rE ", col6 = " & rF & " WHERE primaryKey = '" & primary "'"

3
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by Mabolo
0

mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & ", col4 = " & rD & ", col5 = " & rE & ", col6 = " & rF & " WHERE primaryKey = '" & primary "'"

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.