Search found 11 matches
- Mon May 01, 2023 10:42 pm
- Forum: General Discussion
- Topic: loop thru text file or database records and execute sql
- Replies: 1
- Views: 4796
loop thru text file or database records and execute sql
Without going into too much detail as to why I have to do this, I want to explain what I want to do. I want to create a table where each row is a sql command I want to run. These could be queries, possibly with parameters, could be inserts, deletes. I would like to be able to loop thru these records...
- Sat Mar 25, 2023 5:03 am
- Forum: General Discussion
- Topic: Task Step Completes but doesn't go to next step
- Replies: 1
- Views: 4260
Re: Task Step Completes but doesn't go to next step
I see the robotask restart task so I will try that.
Alan
Alan
- Sat Mar 25, 2023 4:31 am
- Forum: General Discussion
- Topic: Task Step Completes but doesn't go to next step
- Replies: 1
- Views: 4260
Task Step Completes but doesn't go to next step
I am running a MySQL Stored procedure in a task step. So I open the database, DB Exec SQL which does a call to the stored procedure, than dbclose The stored procedure for sure completes, as the last statement updates a value in a table and that's happening, but the Task still shows as running. Is th...
- Wed Mar 22, 2023 9:48 pm
- Forum: General Discussion
- Topic: Use Variable for Connection String
- Replies: 3
- Views: 5616
Re: Use Variable for Connection String
I got it. I was just doing it wrong.
Thanks
Alan
Thanks
Alan
- Wed Mar 22, 2023 9:46 pm
- Forum: General Discussion
- Topic: Use Variable for Connection String
- Replies: 3
- Views: 5616
Re: Use Variable for Connection String
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 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
- Wed Mar 22, 2023 5:16 pm
- Forum: General Discussion
- Topic: Use Variable for Connection String
- Replies: 3
- Views: 5616
Use Variable for Connection String
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 ...
- Sat Mar 18, 2023 4:37 pm
- Forum: General Discussion
- Topic: Can't delete task steps
- Replies: 2
- Views: 5697
Re: Can't delete task steps
It the program itself I tried to update but it said no newer version existed, but I downloaded and installed from the website and all is good.
- Sat Mar 18, 2023 4:56 am
- Forum: General Discussion
- Topic: Can't delete task steps
- Replies: 2
- Views: 5697
Can't delete task steps
Using RoboTask 9.5.1.1109 x64
I have some task steps that I no longer want.
If I highlight the task step, right click and say Delete, it won't delete the step.
Seems like I must be doing something simple wrong.
Alan
I have some task steps that I no longer want.
If I highlight the task step, right click and say Delete, it won't delete the step.
Seems like I must be doing something simple wrong.
Alan
- Thu Feb 02, 2023 4:16 am
- Forum: General Discussion
- Topic: Connect to MySQL thru SSH Tunnel
- Replies: 0
- Views: 34651
Connect to MySQL thru SSH Tunnel
Is there a way to connect to MySQL thru an SSH Tunnel and run mysql commands?
Thanks
Alan
Thanks
Alan
- Mon Jul 04, 2022 7:30 am
- Forum: General Discussion
- Topic: Multiple installations
- Replies: 2
- Views: 3900
Re: Multiple installations
I just found licenses section in help.
One installation per license.
I missed bitsdujour 60% that happened a few days ago. They have 30% off now.
You can cancel this post but would it be possible to get a good discount if I purchased 2 licenses?
One installation per license.
I missed bitsdujour 60% that happened a few days ago. They have 30% off now.
You can cancel this post but would it be possible to get a good discount if I purchased 2 licenses?