Screenshots

Adding objects to the query, automatic joins creation

Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Working with Active Query Builder you may easily add objects to your query by dragging them from the database objects tree or using the special Add Object window. Objects might be grouped by database, schema and type.

Objects linked with foreign keys are joined automatically. You may allow or deny the end-user to create and remove joins manually.


All screenshots

zoom
Adding objects to the query, automatic joins creation
Adding objects to the query, automatic joins creation
zoom
Defining different join types and server-specific options
Defining different join types and server-specific options
zoom
Easy sorting, grouping and criteria definition
Easy sorting, grouping and criteria definition
zoom
Working with Unions, Sub queries and Derived tables
Working with Unions, Sub queries and Derived tables
Related pages
scroll to top
© Copyright 2005-2007 ActiveDBSoft. All rights reserved.
Site Map Terms of Use Privacy Policy

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.
CodeGear - Where Developers Matter