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
parameter issue - must declare scalar variable
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
parameter issue - must declare scalar variable
- Attachments
-
- must declare the scalar variable.png (140.16 KiB) Viewed 655 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: parameter issue - must declare scalar variable
Hello,
Please add it as a parameter in the data source.
Thank you.
Please add it as a parameter in the data source.
Thank you.
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: parameter issue - must declare scalar variable
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)
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)
- Attachments
-
- datasource parameter.png (33.33 KiB) Viewed 648 times
-
- data source parameter size.png (8.51 KiB) Viewed 648 times
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: parameter issue - must declare scalar variable
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)
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)
- Attachments
-
- parameter changed.png (44.35 KiB) Viewed 635 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: parameter issue - must declare scalar variable
Hello,
Thank you for the information.
Thank you for the information.