RoboTask forum

I connect to a mysql database quite often in my scripts.

Is there a way to set a global variable with the connection string and use that when I connect to my database server?

That would help a lot as I have to change my password every 90 days. I would only need to change in one place if it could be a variable.

thanks
Alan

Use menu Options->Variables and open "Global user variables" tab
Then you can use this variable in your tasks

I set the variable up, however in the DBOpen and in the dataset loop I don't appear to be able to use a variable for the Connection String.

I put {EDDDB} which is the name of the User Global Variable in the Connection String but it doesn't work when I Test it.

Alan

I got it. I was just doing it wrong.

Thanks
Alan