| PRODUCTS » INTRAWEB COMPONENTS » TMS INTRAWEB QUERY BUILDER |
v1.4 (May 5, 2008)
|
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)
BOOKMARKS
TMS IntraWeb Query Builder
Provide codeless powerful ad-hoc query capabilities in IntraWeb web applications
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

free updates for a full version cycle (from current version to v2.3) and free priority support:
70 EUR
for Delphi 6, 7, 2005, 2006, 2007, C++Builder 6, 2006, 2007
order immediately
Via ShareIt service:
Please choose your language and order immediately or add to cart

free updates for a full version cycle (from current version to v2.3) and free priority support:
275 EUR
for Delphi 6, 7, 2005, 2006, 2007, C++Builder 6, 2006, 2007
order immediately
Via ShareIt service:
Please choose your language and order immediately or add to cart
Copyright © 1995 - 2008 TMS Software


ONLINE ORDERS
Subscribe to RSS Feed