Author: Sergey Smagin

Firebird 2.1 CTE are supported by Active Query Builder

Leave a comment
Active Query Builder logo

Active Database Software announced release of the new minor version of Active Query Builder, a true two-way visual SQL query builder component that allows end-users to build complex SQL queries via the intuitive visual interface. The component is available as VCL and ActiveX control, as well as .NET WinForms component.

Recent improvements include:

  • Support of Common Table Expressions (CTE) for Firebird 2.1 and higher,

ActiveDBSoft announces new minor version of Active Query Builder

Leave a comment
We’re glad to announce the new minor version of Active Query Builder component and grant you a special 25% discount on Active Query Builder for the whole Christmas season!
Learn more about Active Query Builder special Christmas offer.

What’s new in Active Query Builder 1.7.5?

  • We have implemented retrieval of extended information about user parameters in the query: data type, related table and field names.
    Most of demo projects now have example of retrieving such information.
  • We have made the new property to get access to output columns of the query. It allows you to retrieve maximum information about output columns: SQL Expression and alias of expression, Object name, Object alias and Field name.
  • Better handling of the asterisk item in SELECT list: now the asterisk item (*) is added to a query by default and removed automatically when any other item is added to SELECT list.
  • Multiple fixes and improvements for InterBase/Firebird dialect.

Active Query Builder is a visual query building component (Delphi, ActiveX, .Net-ready) with user-friendly interface and unique query research abilities.
Learn more about Active Query Builder

Active Query Builder v. 1.6 released

Leave a comment
Active Query Builder logo

Active Database Software announces today the release of Active Query Builder 1.6, a suite of robust and feature-rich .NET-ready ActiveX and VCL components, which allows your end-users to build complex SQL queries via the intuitive visual interface.

Active Query Builder features: