此頁只有英文版

Virtual objects for Active Query Builder

New version adds support for virtual database objects and fields.

放大 [+]

Building a SQL query with Active Query Builder.

Active Query Builder is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder Java Edition is a Swing-based Java bean component built using JRE 6 (1.6) and supports all modern Java development environments including NetBeans, Eclipse and IntelliJ IDEA.

The following editions are available:

• Active Query Builder .NET Edition
• Active Query Builder ActiveX Edition
• Active Query Builder Java Edition
• Active Query Builder VCL Edition

Updates

New features in all editions:

• New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries behind ordinary fields and save derived tables as ordinary database objects. See the Virtual Objects And Fields source code sample for demonstration and details.
• Now it's possible to add Common Table Expressions visually using the context menu item of the query building area.
• MS SQL Server, Sybase: Support of the old-style TransactSQL outer join operators ("*=" and "*=") is made. 

Additional new features in .NET and Java Editions:

• Metadata and syntax providers for Microsoft SQL Server Compact Edition are made.
• Portuguese (Brazil) and French translations are added.   

About Active Database Software

Active Database Software, Ltd. is a privately owned software development company. Established in 2005, Active Database Software offers solutions for professional database developers especially designed to make software development easier, faster and more effective. It aims to provide technologies which save development time by combining powerful capabilities with unmatched ease-of-use.