Query Maker for Delphi

Query Maker

Disabling the Query Maker User Interface

Query Maker is designed to let you selectively hide parts of its user interface if your application requires more control. For instance, rather than having the user proceed through all of the previously listed steps, you can use Query Maker to just gather records that meet your user's ad hoc criteria and return these records to your application via a dataSet property of Query Maker's main component. You can even restrict Query Maker to just generating SQL code, but not executing it. This is useful if you need to pass SQL code directly into a database engine other than the Borland Database Engine (BDE).

One way you control how much Query Maker should do for you is by assigning a value to its ExitQueryMakerWhen property:

     ExitQueryMakerWhen value     Causes Query Maker to
     ---------------------------  -----------------------------------------
     SQL_Built                    When the user runs a selected query, an
                                  SQL SELECT statement is built but not
                                  executed.  The user is returned back to
                                  your application which can then access
                                  this SQL statement (as a TStringList
                                  property).

     SQL_Built_Run                When the user runs a selected query, a
                                  SQL SELECT statement is built and 
                                  executed.  If the query finds any records,
                                  your user is returned back to your
                                  application which can then access and
                                  report upon these records through a
                                  dataset property of Query Maker's TQuery
                                  component. 

     SQL_Built_Run_Browsed        When the user runs a query, a SQL SELECT 
                                  statement is built and executed.  If the 
                                  query finds any records, they are displayed
                                  in a searchable grid.  The user stays 
                                  within Query Maker and can continue to
                                  modify, run and create new queries.

     SQL_Built_Run_Browsed_Output This option provides the same features as
                                  the above “SQL_Built_Run_Browsed” option
                                  with the additional ability to create and
                                  print the results to a report (Column, Form
                                  or Summary/Detail layout).

If you know which query you want to execute, you can run it directly without requiring the user to interact with Query Maker's user interface. To do this, you would use its Run_Query method which will let you run a query that you specify by its unique identifier. For example:


       cQuery_id := 'AA0000001'; {Query's unique identifier}
       bBuild_and_Run := True;   {Build and execute the SQL SELECT}
       bBrowseResults := True;   {Show results in a searchable grid}

       QMaker1.Run_Query(cQuery_id, bBuild_and_Run, bBrowseResults);

Return to the Query Maker for Delphi Main Page
User Interface for Creating Queries
Driven by a Data Dictionary
Database Storage Enables Quick Access to Prior Queries
Easy to Integrate and Call
Look at Data Dictionary

Prices include full source code and a royalty-free license.

Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404