| T20 - Create an application that takes order information and inserts into database |
| Task Description |
Create an application that asks user for order information and insert it into database. Typically creating a simple application like this and deploying it takes quite a bit of time. With Automation Anywhere you can do it within few minutes.
|
| Solutions |
 |
Create a new task
Click on New -> Task Editor |
Screenshot 1
Screenshot 2 |
 |
Connect to the database
Using the Database command from the Application category, specify a connection string to connect to the Database.
Connect to '<database connection string>' |
 |
Prompt the user for values
Using the Prompt Command from the Keystrokes/Mouse category, Insert a prompt to prompt users for values for a particular column in the database, and assign it to a variable.
Prompt Message : "Enter OrderNo" |
 |
Specify a INSERT Query
Using the Database command from the Application category select, "Insert/Update/Delete" Option. Specify the Insert Statement in the textbox given.
Execute SQL Statement: Insert into OrderMaster Values($Value1$,'$Value2$','$Value3$',$Value4$,$Value5$)
$Value1$ to $Value5$: They are variables which have the values, accepted by the user using the Prompt command. |
 |
Disconnect the Database
Using the Database command from the Application category select "Disconnect" Option. |
 |
(Optional) Create Exe and deploy the application on many machines
If you want to install this application on many machines, you can easily do it without installing Automation Anywhere on all machines.
With Automation Anywhere - Premier version you can easily convert this task to Exe. These exes are standalone programs and don't need Automation Anywhere installed. You can copy the exe on other machines or network drive and many users can use it. |
|
| When you run this task, it connects to the database, prompts the user to enter values for order information and inserts the respective values in the Database Table. |
| |
|
 |
| We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys. |
- Jack Greenberg
|
| Read Customer Testimonies >> |
|
