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!!
Hi to all,
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
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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.