| Home > Solution Guides > How to create an application that takes order information and insert into database? |
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:
|
|
Related Downloads: |
 |
DVD Power Burner is leading DVD/CD burning software that burns data, audios, videos, and images...
|
|
|
|
|
|
| Hot Software |
Cannot open MKV files by default media player? What exactly you need is an MKV to AVI converter....
Utilize Your PowerPoint and you can convert them to various formats now! Convert your PPT to...
DVD Cloner, 1Click DVD Copy and Copy DVD Gold - powerful DVD copy software, help you copy, rip,...
This article shows the TOP 10 best video to 3GP software that the editors pick out for you. You...
Top 10 popular data backup & recovery software for you! Backup your important documents in case...
|
| Editor Reviews |
 Jarod Simmons Good: A helpful utility, quickly backup and restore the hard drive, supports nearly all the...
Dr. File Finder DriveScrubber, by iolo technologies, LLC is a neat utility program that really cleans a hard...
Lucy Lee Create your own web site without any knowledge of HTML. Strength: Namo Webeditor Professional...
Dr. File Finder FolderCloak, by filesee.com is an interesting utility that lets you hide folders so others can't...
Jackie Lee Agent, by Forte is a powerful, first-rate newsreader and it's gotten progressively better over...
|
|
08/21/2007
