Inserting variable into non query statement for updating database

Hi to all,
I want to update a MS Access database by using the execute nonquery activity but I can’t figure out what is wrong with my code. When I run it I get the “Too few parameters” exception. When I replace @Num with an actual string value, let’s say ‘2354’, my access file gets updated correctly. However, when I try to pass an argument it does not work.
Thanks in advance!!

Perhaps the parameter needs to occur outside of the string literal:
"Update RegistroDocumentos SET Ingresado_en_Lotus = “& true &” WHERE Numero = " & @Num

Just a guess, I’ve never used this activity.

Well, I managed to solve my problem by writing the following:

So… I kinda solved the problem, but still don’t know how to use the parameters thing. I hope someone could shed some light on this

1 Like


For the parameters you have to use the name alone without @ in the parameters name, while pasing use the @ charecter.

Main.xaml (5.6 KB)



Thank you!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.