| Solution |
| 1. |
Create new task |
Click on Tools -> 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 Insert 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.
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. . |
| 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. |
