Author: Michael Holopov
E-Mail: holopov@softhome.net
WEB: http://www.chat.ru/~holopov
Great tool for visual queries building for Microsoft Access
databases. This library can be attached at any programming
interface as OLE Automation object. Works via DAO 3.6. Can be
used with any different programming language: Delphi, C++Builder,
VB, etc.
The main window consists of forth parts. Left-top site contents
list of tables and queries in the Database. On the right-top site
is schema of tables(queries) which you want to include into your
output query. Blue lines are links between selected tables. Tree
view on the left-bottom site displays fields which you want to
select in your output query. Each field has some properties
displayed on the right-bottom site.
To add a table (or query) to the schema - drag-and-drop this
object from the table's list. Also you should drag-and-frop field
from one table to another to make a join. The Link can be one of
three types: INNER, LEFT and RIGHT join. After adding link you
can change this type: just right-click on the link and select its
properties from popup menu.
Next step for building is adding output fields and conditions. To
add output field double-click or drag-and-drop one or more fields
from table to tree view. Then set its properies and conditions.
Condition is a criteria for filtering output query. You can use
following operators: =, <, >, Like, <>, Between, is
null (for example =42
for number fields or LIKE 'Mon*'
for character fields). If you type more than one conditions on
another rows, they will be joined as OR-operator. To make another
condition as AND-operator you should add the same field next
time, uncheck button "Display" to prevent duplicate
output and type another condition.
Groupping, group operations (Sum, Count, Avg, etc.) and
conditions for groups (Having clause) are also supported for you
queries.
To see SQL-text for output query select "SQL" Tab.
To save your query-schema to the file select "Save
query" button on the toolbar or press CTRL-S.
To open previously saved query select "Open query"
button or press "CTRL-O".
To accept and return query to your application select
"OK" button. "Cancel" will close window
without saving any changes.
For application's developpers:
Query Builder a dynamic link library which incapsulates COM
technology and you can use it after registering in the system:
REGSVR32 QBuilder.DLL
After that you can create new single instance of a class
"QBuilder.Dialog" by calling CreateOleObject function
(in Delphi). Newly created object has only one function:
function ShowQB( DBName, SysDBName, UserName,
Password: String; LangId: Byte ) : String;
This function open QBuilder modal window. If user select
OK-button, functions return SQL-query as String type, otherwise
it return '-1' as String type too.
Example for Delphi:
Procedure TForm1.Button1Click(Sender: TObject);
var
QB : OleVariant;
SQL : String;
begin
QB := CreateOleObject( 'QBuilder.Dialog' );
SQL := QB.ShowQB( DatabaseName, SystemDBName, UserName, Password, 0 );
// Last argument is LangId. 0 - english interface, 1 - russian interface
if SQL <> '-1' then
begin
Query1.SQL := SQL;
Query1.Open;
...
...
end;
end;
To test my QBuilder I have made a small module on the Visual
Basic...
Example for Visual Basic:
Public Sub Main()
Dim QB As Object
Dim SQL As String
Set QB = CreateObject("QBuilder.Dialog")
SQL = QB.ShowQB("d:\temp\mir2.mdb", "d:\temp\opir.mdw", "cool", "pirog", 0)
If SQL <> "-1" Then
MsgBox SQL
End If
End Sub
Shareware limitation
Unregistered version of Query Builder will work during 2 weeks
after first run.
After this period user must stop evaluation or register (See
Registration section).
To register this application please go to the
following URL:
http://www.regsoft.net/purchase.php3?productid=31146
or
Customers can also purchase and register your software via a
TOLL-FREE Voice Order Line at 1-877-REGSOFT (1-877-734-4638), or
by fax at 770-497-9234. The Product ID # is REQUIRED for both
Voice and Fax orders. Product ID is 31146.
Registration fee - $35
After registration you will receive via E-Mail the Serial number
which you should
enter (Help->Register menu).
А теперь немного
по-русски! Если запустить кубилдер
с последним параметром в функции
равным 1, то он не просто будет с
русским интерфейсом, но и абсолютно
фриварным, т.е. не требующим
регистрации и работающим
бесконечно долго. Только одна
просьба: сообщать мылом мне обо
всех замеченных глюках!