Search found 11 matches

by asawyer13
Mon May 01, 2023 10:42 pm
Forum: General Discussion
Topic: loop thru text file or database records and execute sql
Replies: 1
Views: 865

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...
by asawyer13
Sat Mar 25, 2023 5:03 am
Forum: General Discussion
Topic: Task Step Completes but doesn't go to next step
Replies: 1
Views: 1203

Re: Task Step Completes but doesn't go to next step

I see the robotask restart task so I will try that.

Alan
by asawyer13
Sat Mar 25, 2023 4:31 am
Forum: General Discussion
Topic: Task Step Completes but doesn't go to next step
Replies: 1
Views: 1203

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...
by asawyer13
Wed Mar 22, 2023 9:48 pm
Forum: General Discussion
Topic: Use Variable for Connection String
Replies: 3
Views: 1237

Re: Use Variable for Connection String

I got it. I was just doing it wrong.

Thanks
Alan
by asawyer13
Wed Mar 22, 2023 9:46 pm
Forum: General Discussion
Topic: Use Variable for Connection String
Replies: 3
Views: 1237

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
by asawyer13
Wed Mar 22, 2023 5:16 pm
Forum: General Discussion
Topic: Use Variable for Connection String
Replies: 3
Views: 1237

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 ...
by asawyer13
Sat Mar 18, 2023 4:37 pm
Forum: General Discussion
Topic: Can't delete task steps
Replies: 2
Views: 1540

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.
by asawyer13
Sat Mar 18, 2023 4:56 am
Forum: General Discussion
Topic: Can't delete task steps
Replies: 2
Views: 1540

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
by asawyer13
Thu Feb 02, 2023 4:16 am
Forum: General Discussion
Topic: Connect to MySQL thru SSH Tunnel
Replies: 0
Views: 22330

Connect to MySQL thru SSH Tunnel

Is there a way to connect to MySQL thru an SSH Tunnel and run mysql commands?

Thanks
Alan
by asawyer13
Mon Jul 04, 2022 7:30 am
Forum: General Discussion
Topic: Multiple installations
Replies: 2
Views: 1526

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?