Table of Contents
- Cross-Browser Scripting (CBS)
- Chrome Extension
- Firefox Extension
- General Information
- Interface Control Manager Parameters
- Time Settings
- Scenario Flow
- On Success
- On Fail
Database: Run SQL Command
Data Access Component Usage Video
This is the step that performs the process of sending a SQL Command to the connected database via VooDoo Studio.
You can follow the image below to reach the database steps.
|The name of application execution step. (Compulsory)
|The description of application execution step. (Not Compulsory)
|Related Flow Image
|The using image during this step. (Compulsory)
|Open Connection Step
|This is the parameter that defines the step that creates the database connection.
Note: Do not forget to press the “Connect” button to make the connection to the relevant database.
|SQL: Schema Explorer
|This is the Schema Explorer area where you can access the schemas in the database after connection with the database.
|After the connection with the database, it is the Command field where you can send SQL Commands to the database.
Note: After writing the SQL command for the relevant database, Don’t forget to press the “Run” button.
|It is the Parameter data returned from the database after the database command is sent.
Key: It is the key field name parameter of the data source manipulated by the user in the database.
RuntimeValue: It is the runtime parameter of the relevant intervention, which is returned from the database to the user.
DesigntimeValue: It is the parameter of the relevant intervention, which is returned from the database to the user, describing the duration of the database design intervention.
|It is the Output data returned from the database after the database command is sent.
Upload Output to Datasource: It is the Selection parameter of whether or not to save the output data obtained after the database command to the data source.
Data Source: If the output data is to be saved in the data source, the Data Source parameter is the data source where these outputs will be saved.
|SQL: Execution Result
|The Records Affected parameter returned from the database after the database command is sent.
Displays the numeric value of the data fields affected by the command to the user.
|Maximum Step Completion Time
|The time to the end of completion for step if Run to The End of Completion of Application style is chosen. (Compulsory)
|Wait Time After Execution Request
|The wait time to pass next step. (Compulsory)
Indicates the step flow type. (Compulsory)