parameter issue - must declare scalar variable

[dmasterplan]

Hi,

I created a variable and set it as a parameter (please see attached image),
but when previewed, it triggers an error "Must declare scalar variable"

Haven't done this before. Please help.

Great Thanks

[Lech Kulikowski]

Hello,

Please add it as a parameter in the data source.

Thank you.

[dmasterplan]

I added a parameter in datasource (image attached) but still triggers an error:
OleDbCommand.Prepare method requires all variable length parameters to have an explicitly set non-zero Size.

so I set a size BUT there is still an error.
"Syntax error or access violation"
(image attached)

[dmasterplan]

Hi,

I want to thank you for your help.
I changed calling of the parameter the way we actually do it and it worked.

(see image attached)

[Lech Kulikowski]

Hello,

Thank you for the information.