Databaseloop mysql using variables

Discuss RoboTask here
Post Reply
steven
Posts: 1
Joined: Fri Jan 06, 2023 12:05 pm

Databaseloop mysql using variables

Post by steven »

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?
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: Databaseloop mysql using variables

Post by Oleg »

I's better to use parameters in your SQL expression
read more here please
Oleg Yershov
Post Reply