Page 1 of 1
Temporal table on SQL-server
Posted: Mon Mar 21, 2016 2:51 pm
by steelunicorn
Seems that #table i'm creating in query is being destroyed because Robotask closes session to SQL-server. But after creating #table i want to insert data into it in dataset loop. Is there option avaliable to create session and work with it without autoclosing it?
Re: Temporal table on SQL-server
Posted: Wed Mar 23, 2016 8:20 am
by Oleg
RoboTask has only two DB-relative actions:
SQL Query and
Dataset Loop
Each action opens its own session.
SQL Query closes the session after execution
Dataset Loop keeps the session opened only within the loop.
Re: Temporal table on SQL-server
Posted: Thu Mar 24, 2016 8:35 am
by steelunicorn
That's strongly limits range of possibilities in tasks working with SQL. If I may suggest, it wold be usefull to have actions like "Start SQL-session" and "Close session" in loop-like design.
I mean like this:
1. "Start session"
2. Some actions
3. Some other actions
4. Even moar actions
5. "Close session"
Re: Temporal table on SQL-server
Posted: Thu Mar 24, 2016 9:52 am
by Oleg
Yes, maybe it's necessary to add these actions. It will be the set of database actions.
I already wrote this into our ToDo list.