Automation Anywhere - The Automation Software

Sample Tasks -> 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.

Solution
1.	Create new task	Click on New -> Task Editor.
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>'.
3.	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"
4.	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. (Screenshot 1) 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.
5.	Disconnect the Database	Using the Database command from the Application category select "Disconnect" Option. Screenshot 2.
6.	Optionally 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.