by jking Thu Jun 07, 2018 4:24 am
The Store In Database step only works when storing in a Database on Management Console. It acts the same as an Insert Into SQL Statement.
If you are not trying to update a table in Management Console, you will need to use an Execute SQL step and use an Insert Into or Update SQL Statement.
In order to Store In Database you need a Type and you need to Create a Database Table in a Database on Management Console.
Add new Type
Name Type
Add Attributes
Save Change
NB: You must have a Database Key included in your type.
Click Tools → Create Database Table
In the Database drop-down Option, Select the Database where you want your Table Created (a database on management console)
Click the Check Box next to your Type
Click Generate SQL
Kapow will auto-generate a CREATE TABLE sql statement based on the Attributes added above.
Click Execute
Click Close
Go To Management Console → Data Tab and check that the Type was added as a new Database Table.
Refresh your Robot.
Add the Type you created as a Variable. I would suggest that you name the Variable the same name as your Type/Table.
Click OK
(Click Execute in Design Mode if you want the Store In Database Step to execute in Design.
When you step pass the Store In Database the value(s) assigned to the Type in the Robot will appear in the Table in Management Console.
To use the stored data in robot two, you will query the table you created from your type.
Database is the database from Management Console
Select * from TableName where, etc.
In the Save in Database Step:
Database is the Database on Management Console where you created your Table from your Type
Variable: The Type you Created