SQL Wizard

Home

Demos
On line demos

Services
Professional
Development
Services

Application
Hosting

Contact Us
Phone &
Email

SQL Wizard

BulletProof's innovative SQL Wizard invokes a set of screens to give point and click power for creating SQL Statements and add them automatically to your code. Either insert the necessary code into the selected method or create a new method to perform a SQL on the Server.

The purpose of the SQL Wizard is to allow you to quickly generate the source necessary to perform a SQL command on the server while at the same time avoiding the chance of a typo, misplaced quote or invalid syntax that would otherwise slow your development effort. We're sure you'll find this to be a great time saving feature. Not only does the wizard create the SQL, it also creates the Java code to run it. As an added feature you can run the SQL's on the fly and get the results just to be sure the SQL is what you really wanted.

The SQL Wizard consist of three tabs. They are as follows:

Select Database - select the database to run the SQL against.
Define SQL Statement - define the Select, Insert, Update, Delete or Stored Procedure you wish to execute.
Show SQL Results - view the output of this SQL to check that it's what you are expecting.

Select Database

For more detailed information see the on line manual.

Define SQL Statement

This tab allow you to choose the from the following types of SQL that can be run on the server:

Select - select row(s) from table(s) in the selected database and place them into resultant variables in your application.
Insert - insert a row into a table in the selected database using data from variables in the current application.
Update - update row(s) in a table in the selected database using data from variables in the current application.
Delete - remove row(s) from a table in the selected database using key values from variables in the current application.
Stored Procedure - run a stored procedure on the server passing parameters supplied with data from variables in the current application and return results into variables in the current application.

Show SQL Results

When you have successfully constructed your SQL you can run it to see the results returned.