How to create an application that takes order information and insert into database?
|
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 ' |
|
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. | ||
Screenshot 1:
Screenshot 2:
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.
Tags:Automation Anywhere, import data from excel to acess, automate complex task, intelligent automation software for it, intelligent software, automation software for business
Top Reviews
on Web Developer
Adobe Flash Player - SWF Player"Cross-platform flash video plug-in for web browsers to deliver users wonderful visual effects."
by Owen Wilson on Sep 7, 2009
Flash Gallery Builder"Flash Gallery Builder Reviews & Free Download"
by Heren Watson on Jan 10, 2008
