QweryBuilder, is a unique database development tool with a very simply purpose, to make accessing data from a database simple, quick, accurate and efficient. QweryBuilder implements innovative ideas to make this possible. An end user can extract and update data without writing a line of SQL. Database developers can create procedures, tables, views and triggers with fewer keystrokes. It currently works with Sybase ASE, iAnywhere SQL Anywhere, Microsoft SQL Server and Oracle. An evaluation version of QweryBuilder can be downloaded from www.Werysoft.com.
Criteria Query Window
The Criteria Query window is one of the cornerstone features of QweryBuilder. It allows you to select a table from your database, enter criteria for that table then retrieve the results. Selecting an item from the table list will display all the columns in a freeform view for that table. You are then able to enter the data you want to retrieve (i.e. criteria). See Figure2.
Data will be retrieved in a new tab. These results are fully updateable. You can change the data, delete rows, insert rows or import data from a file. Once you’re done manipulating the data you simply click the update button to commit your changes.
Graphic Query Window
The Graphic Query window allows you to query your database graphically. This means that you can generate a SELECT statement with just your mouse, no key strokes necessary, see Figure3. When the window first opens you will be asked to select the tables that you want to be part of the query. The selected tables will display in the Graphic Query window, displaying the columns contained within. Click on the columns that you want to be included in the SELECT statement. On the toolbar within the window you will see an option that will let you tether tables together, allowing you to create relationships graphically.
Autocomplete and MyAutocomplete
One of the great features of QweryBuilder is the intellisense found in the SQL Editor window. It assists you as you type your ad-hoc queries. You can display a list of tables by typing in the database owner (e.g. dbo) followed by a period (.). Or you can simply enter Ctrl-Space. To bring up a list of columns for a table type the name of the table followed by a period, or type the table alias you entered in the FROM clause then enter a period. To bring up a list of database owners\schema’s, type the word “this” followed by a period.
E.g.
SELECT A. <– Autocomplete window will display here
FROM MyTable A
SELECT *
FROM dbo. <– Autocomplete window will display here
Another feature in QweryBuilder, known as My Autocomplete, allows you to get quick access to data within your database via the intellisense window. The My Autocomplete feature (Tool/My Autocomplete) can display a list of data retrieved from the database or data that has been manually typed in. So why would a feature like this be handy? I know in a support role you are constantly querying the database looking for information based on “key” data. Let me provide an example. Let’s say a popular query is to find all employee’s by department. Your database will contain an Employee table and a Department table. The Employee Table will contain a foreign key back to the Department table called DeptId. If you need to find all employees in the HR department you will have to first look up the key for the HR department. Once you have this key you will then use it to query the Employee table. So really what you’ve done is create an SELECT statement, executed it, copied the results from the results window or memorized it, created another query for the Employee’s table then entered your department. I know this is not too many steps but it should be easier.
To do this example the QweryBuilder way, open the My Autocomplete window. Enter a new item by clicking the “new” button. Provide a name (e.g. dept); this name will be used in the query window so keep it short. From the type drop down select Command. Enter the following syntax:
SELECT DeptId, DeptName
FROM Department
The column order in the above SELECT statement is important. You want the key column first (the column value that will be inserted into the editor) then the descriptor column second. In your SQL Editor window you can then type the following:
SELECT * FROM EMPLOYEE A
WHERE A.DeptId = dept. <– dept is the name we specified in the My Autocomplete window.
After entering the period you will see that the word dept is removed (it’s not valid for our query) and a list of data is retrieved and displayed (the results of the query we entered in the My Autocomplete window). Find your department and select it. Once you have your department selected you can click enter or tab to insert the key value into your editor window.
Other Features
Format SQL
Check Syntax
Generate CRUD Report
Form View Results.
You can view your query results in a form view next to your regular result set. The idea behind this is that you can scroll vertically through your results while easily seeing all the data in the row without having to scroll horizontally.
Create a Table from Results.
After you select results from the database you can turn those results into a new table. The results can be from a single table or it can be data from multiple tables. The generated script will also provide you with all the INSERT statements for the data you retrieved.
Create Insert Statements from Results.
The idea of creating insert statements is the exact same as what was described in the previous paragraph. This is a good feature because it allows you to copy small amounts of data from one database to a similar table in another database.
Sort Columns.
I can’t count the number of times I’ve retrieved information from a really long table (i.e. a table with many columns) then get lost while scrolling through the results looking for 1 particular column. With QweryBuilder you can sort the columns in your result set so you can easily find the column you’re looking for. It’s a bit of a time saver sometimes.
Filter Results.
After you retrieve your results it may be necessary to further limit those results. Clicking the button seen in Figure 6 will open a filter window. Enter your filter criteria and close the window.
Database Search
QweryBuilder comes with a database search window. You can enter a search string and select the type(s) of database objects you want to search. The application will extract the DDL for each type of database object you selected and search for your strings. If the string is found it will display it in a treeview. Clicking on the name of the found item will display the object in an editor window so you can easily see where the string was found. The search results can then be printed or saved. This allows you to access your results in another program like Excel.
Conclusion
Our mission at Werysoft is to be the leader in the database development tools market. Our goal is to provide our end users with the software they need to be productive while working with the largest databases in use today.
We pride our self in our ability to develop creative solutions to tough problems. This allows us to realize our goal of making you more productive. Our hope is that you see this in QweryBuilder.
