Databaseloop mysql using variables
Posted: Fri Jan 06, 2023 12:26 pm
Can I declare variables in my database loop?
When I select this @number:=200 fldtest in mysql workbench I get a result...
In the database loop I get an error: "Parameter object is defined incorrectly. Inconsistent or incomplete information has been provided."
I tried to use sql parameters but not working.
Normal select statements do work. my connectionstring = Provider=MSDASQL.1;Persist Security Info=False;Data Source=DotCube_on_site.
Anyone any idea?
When I select this @number:=200 fldtest in mysql workbench I get a result...
In the database loop I get an error: "Parameter object is defined incorrectly. Inconsistent or incomplete information has been provided."
I tried to use sql parameters but not working.
Normal select statements do work. my connectionstring = Provider=MSDASQL.1;Persist Security Info=False;Data Source=DotCube_on_site.
Anyone any idea?