Ask Your Question
0

Help with macro syntax error

asked 2020-05-14 22:56:44 +0200

gkick gravatar image

Hi,image description

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-05-14 23:19:35 +0200

Ratslinger gravatar image

updated 2020-05-14 23:27:31 +0200

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

edit flag offensive delete link more

Comments

1

Hmm - isn't there a missing " after tFilter and it should read:

SQL = "UPDATE ""tFilter"" SET ""jobid"" = '" & invno & "'"

?

Opaque gravatar imageOpaque ( 2020-05-14 23:23:46 +0200 )edit

Yes! Thank You Very Much! Will correct. Did not need to delete your ans. was going to delete mine. Just a timing thing.

Ratslinger gravatar imageRatslinger ( 2020-05-14 23:27:04 +0200 )edit

Thank you very much! Appreciated.

gkick gravatar imagegkick ( 2020-05-15 00:20:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-14 22:56:44 +0200

Seen: 37 times

Last updated: May 14