Page 1 of 1
parameter issue - must declare scalar variable
Posted: Thu Jun 02, 2022 9:48 am
by 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
Re: parameter issue - must declare scalar variable
Posted: Thu Jun 02, 2022 10:12 am
by Lech Kulikowski
Hello,
Please add it as a parameter in the data source.
Thank you.
Re: parameter issue - must declare scalar variable
Posted: Thu Jun 02, 2022 11:15 am
by 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)
Re: parameter issue - must declare scalar variable
Posted: Thu Jun 02, 2022 1:47 pm
by 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)
Re: parameter issue - must declare scalar variable
Posted: Thu Jun 02, 2022 8:49 pm
by Lech Kulikowski
Hello,
Thank you for the information.