TRIAL DOWNLOADS

• Delphi 6 (3.96 MB)
• Delphi 7 (3.96 MB)
• Delphi 2005 (3.96 MB)
• Delphi 2006 (3.96 MB)
• Delphi 2007 (3.96 MB)
• C++Builder 6 (3.96 MB)
• C++Builder 2006 (3.96 MB)
• C++Builder 2007 (3.96 MB)

Purchase a license

BOOKMARKS

TMS IntraWeb Query Builder

Provide codeless powerful ad-hoc query capabilities in IntraWeb web applications

• Feature overview
• What's new
• FAQ
• Online orders

Trial version requires IntraWeb 9.0.32* !
(see www.atozedsoftware.com)
*registered version works with all IntraWeb 7.2.x,8.0.x,9.0.x versions
Included EXE demo can be run without IntraWeb or component install

Feature overview

IntraWeb Query Builder provides an easy way to give users access to powerful queries without requiring any knowledge about SQL. Users can setup complex queries in an almost natural language way with IntraWeb Query Builder. Dropping the component TTIWQueryBuilder on the form and connect to the database opens the visual and full client side query power of IntraWeb Query Builder.

Feature details

• Visual definition of query, in a natural language-like way
• Allows definition of field selection, conditions and ordering
• Fuly client side query-aware editor, minimizing server hits during query building
• Field type sensitive inplace editors
• Supports SQL syntax for Microsoft Access, Microsoft SQL Server, Oracle, MySQL, Nexus, Interbase, DBISAM, IBO, SQLDirect and Local BDE
• Automatically set TDataset properties. Supports BDE, ADO, IBX, DBISAM, Nexus and DBExpress dataset descendants
• Easy language switching
• Customizable language support
• Extendable to support other databases for which no interface component is included

What's New

v1.4

• New: Delphi 2007 & C++Builder 2007 support added
• New: IntraWeb 9.0 support added

v1.3

• New: Delphi 2006 & C++Builder 2006 support added
• New: IntraWeb 8.0 support added

v1.2

• New: Delphi 2005 support added
• New: FireFox & Netscape support added
• Improved: latest SQL parse & generate code
• Various smaller improvements & fixes

v1.1

• New: IntraWeb 7.2 support
• New: SQLDirect components support
• New: IBO components support
• New: SQL Parser now supports field and table names with spaces (e.g., Select "Customer Name" from "Customer Table")
• New: poperty TatIBXDatabase.UseViews
• Improved: Generated SQL statement does not duplicate order by fields, even if end-user duplicated it in visual query
• Fixed: "Could not parse SQL" with more than one space after "AND" and "OR" operators
• Fixed: field-type error message when using Count aggregated function

v1.0

• First release for IntraWeb for Delphi 5,6,7 & C++Builder 5,6
• EXE demo included
• PDF Quick Start guide included

FAQ

Q: How can I use a database component library for which no built-in interface component is provided in IntraWeb Query Builder?

A: You can use TatCustomDatabase component to manually retrieve tables and field names and pass the names to visual query component. Just drop a TatCustomDatabase component and set event handlers for all its events. The example below shows how to use TatCustomDatabase to support BDE components (although it is already supported by the specific TatBDEDatabase component). You must have a TDatabase component in the form named Database1 which points to the DBDEMOS database.

procedure TForm1.atCustomDatabase1ReadSqlPropertyEvent(ADataset: TDataSet;
  var ASQL: String);
begin
  if ADataset is TQuery then
    ASQL := TQuery(ADataset).SQL.Text;
end;

procedure TForm1.atCustomDatabase1RetrieveFieldNameListEvent(
  const ATableName: String; const AList: TStrings);
var
  table: TTable;
  c: integer;
begin
  table:=TTable.Create(nil);
  try
    table.DatabaseName := 'DBDEMOS';
    table.TableName := ATableName;
    table.FieldDefs.Update;
    for c := 0 to table.FieldDefs.Count-1 do
      AList.AddObject(
      table.FieldDefs[c].Name, // FieldName
      TObject(Ord(table.FieldDefs[c].DataType)) ); // DataType
  finally
    table.Free;
  end;
end;

procedure TForm1.atCustomDatabase1RetrieveTablenameListEvent(
  const AList: TStrings);
begin
  Database1.GetTableNames(AList);
end;

procedure TForm1.atCustomDatabase1OpenQueryEvent(ASql: String;
  var ADataset: TDataSet);
begin
  ADataset := TQuery.Create(Self);
  with TQuery(ADataset) do
  try
    DatabaseName := 'DBDEMOS';
    Sql.Text := ASql;
    Open;
  except
    ADataset.Free;
    ADataset := nil;
    raise;
  end;
end;

procedure TForm1.atCustomDatabase1WriteSqlPropertyEvent(ADataset: TDataSet;
  ASql: String);
begin
  if ADataset is TQuery then
    TQuery(ADataset).SQL.Text := ASQL;
end;

Buy online