[ANN] KQB - freeware query builder

From: Serge Korzh (serge_at_korzh.com)
Date: 04/27/04 

Date: Wed, 28 Apr 2004 00:14:42 +0300

Korzh Query Builder (KQB) is totally free tool which provides user-friendly graphical interface for building SQL
statements, perform queries to databases and export the results into different formats. The user of query builder does
not need to know about database design or table relationships. It is possible to describe requests simply by creating
Engish sentences and receive the result immediately.

Main features are:
- Native language user intreface, allowing non-experienced users to issue fairly sophisticated queries;
- A lot of features which simplify process of query building: special value editors for date, time and list values,
ability to get the list of available values from the query, query designer for sub-queries, etc.
- Ability to save and to load created queries and to assign some textual description for built query;
- Instant viewing of generated SQL queries and query results;
- Ability to save the result dataset into several formats (text, DBF files, HTML) and to print it.

Presented Query Builder application is a demo example of the Active Query library.
Active Query pack allows you to include end user oriented SQL query builder into your application. Using it you provide
your users with the ultimate ability to build their own queries and get all the data they want.

To download KQB and for more information about this tool please visit:
http://www.korzh.com/devtools/kqb/

Relevant Pages

  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)
  • Re: Dynamic query problem
    ... On Oct 17, 9:41 am, Andy Hull ... If we were to provide a fully featured dynamic query generator we would have ... Provided with already built queries which they can edit ... SQL and see where it is the same as for the other queries and where it ...
    (microsoft.public.access.queries)
  • Re: CONTAINS performance
    ... mark, FTS needs to be very carefully tuned to achieve second response times, ... see SQL Server 2000 BOL title "Full-text Search Recommendations" for more ... When you include the "TOP 100" in your query, you are in fact limiting the ... valid for SQL queries, they often do not apply to FTS queries because the FT ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)