Screenshot Preview

Active Query Builder adds translations

.NET Edition V1.14.X adds Arabic, French, Italian, Spanish and Swedish, plus improved recursive CTE processing.

Visually building a query for a SQL Server database.
Zoom [+]

Visually building a query for a SQL Server database.

Active Query Builder for .NET 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 .NET Edition supports Visual Studio 2005, Windows.Forms environment (100% Managed Code, No direct Win32 interop calls).

Updates in V1.14.X

Updates in ActiveQuery Builder for .NET V1.14.1.261

  • Fixed parsing of derived tables without alias.
  • Fixed parsing of joins with parentheses.

Updates in ActiveQuery Builder for .NET V1.14.1.259

  • Arabic (Saudi Arabia) [ar-sa] translation is added.
  • Swedish [sv] translation is added.
  • Bug with nested NOT expressions is fixed.

Updates in ActiveQuery Builder for .NET V1.14.0.258

  • Recursive CTE processing is improved.

Updates in ActiveQuery Builder for .NET V1.14.0.257

  • MySQL: CONVERT function is fixed.
  • PlainTextSQLBuilder formatting properties are correctly expanded now (in designer).

Updates in ActiveQuery Builder for .NET V1.14.0.256

  • SqlTextEditor: Fixed exception when the suggestion window is visible on the control disposing.
  • MetadataEditor: Fixed exception when creating foreign keys with drag and drop.
  • Missing strings for "Collapse" and "Expand" commands are added into en.xml translation template file.
  • Source code examples are updated for compatibility with Visual Studio 2008 and 2010.

Updates in ActiveQuery Builder for .NET V1.14.0.255

  • ToolboxManager slightly improved (will hasten installation a bit).
  • de, es, fr, it, pt-br translations updated.
  • DevExpress dependencies of ActiveDatabaseSoftware.DevExpressControlFactory.dll are updated to v10.2.3.0.
  • SqlTextEditor and ExpressionEditor: syntax coloring properties goes public.
  • Server version auto-detection is implemented.
  • Renaming of common table expressions (CTE) is implemented.
  • MetadataEditor: adding and editing of virtual objects and fields are implemented.
  • Images on tabs are implemented. To hide images use ShowTabIcons property.
  • To set custom images use TabsImageList property (must contain 4 images: main query, sub-query, derived table, common table expression (CTE)).
  • Oracle: loading of materialized views is fixed.
  • SqlTextEditor: fixed AVG function highlighting for MS Access syntax.
  • Firebird: DateAdd, DateDiff, Overlay, Position builtin functions are fixed.
  • MS Access: problem with '$' char in builtin function names is fixed.
  • Automatic alias generation is fixed.

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. The company puts a lot of effort in to provide technologies which save development time by combining powerful capabilities with unmatched ease-of-use.