Hi,
Attempting to populate a filter table with a variable. The enclosed code works if I update the table with an integer, but does not like the variable.
Thanks for your help
Hello,
You are making &invno part of the SQL statement. What you need:
SQL = "UPDATE ""tFilter"" SET ""jobid"" = '" & invno & "'"
Another example (a Select statement) here → Sql within a base macro using variables gives syntax error
Hmm - isn’t there a missing " after tFilter and it should read:
SQL = "UPDATE ""tFilter"" SET ""jobid"" = '" & invno & "'"
?
Yes! Thank You Very Much! Will correct. Did not need to delete your ans. was going to delete mine. Just a timing thing.
Thank you very much! Appreciated.