Inserting variable into non query statement for updating database

[sebaaf96 (Sebastián Álvarez)]

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!!

[cclements (Chris Clements)]

@sebaaf96

oo few parameters

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.

[sebaaf96 (Sebastián Álvarez)]

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

[megharajky (Megharaj Yadravi)]

Hello,

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

Example:
Main.xaml (5.6 KB)

Thanks,
Meg

[sebaaf96 (Sebastián Álvarez)]

Thank you!