Downloads

Active Query Builder ActiveX Edition History

April 21, 2008

Active Query Builder ActiveX Edition v.1.9.0.21

+ New properties are added to the IMetadataContainer to specify default database 
  and schemes for omission purposes: DefaultDatabase, DefaultSchemas.
  See also: IActiveQueryBuilderX.ObjectrefixSkipping property.
- The Universal Syntax Provider now changes the IdentCaseSens property correctly
  according to detected database server.
+ MySQL: "Mod" operator issupported, "key" is added to valid identifiers list.
- MySQL connection without the default database specified is supported now.
- Comparison with sets emitted wrong SQL (field = any(select oid from orders))
  in many dialects. Fixed now.
- DB2 Syntax: Built-in functions YEAR, DAY, MONTH, etc. are supported now.
- Oracle Syntax: "YEAR" is added to the list of valid identifiers.

April 17, 2008

Active Query Builder ActiveX Edition v.1.9.0.18

- Sybase syntax: The "join" clause without expressions are supported now. They
  will be converted to the comma-separated tables list.
- PostgreSQL syntax: Database names are loaded case sensitively now.

April 15, 2008

Active Query Builder ActiveX Edition v.1.9.0.16

+ The new demo is added to illustrate working with alternate names of 
  database objects and their fields (Alternate Names Demo).
+ The new demo is added to provide various examples of working with Active
  Query Builder API (Non-Visual Demo).
+ Sybase syntax: The string concatenation operator "||" is supported now.
+ DB2 Syntax: "VALUES" sub-queries in derived tables are supported now.
- Metadata Filter: Creation of SQL pre-filtration expression is corrected.
- Minor fixes in the IMetadataObject.Relations property are made.
- Fixed problem with derived table field's aliases.

April 01, 2008

Active Query Builder ActiveX Edition v.1.9.0.10

+ Sleep mode is implemented. This mode allows you to suppress error messages
  while printing unsupported statements in SQL text editor, connected with
  Active Query Builder. Active Query Builder now switches to Sleep mode when
  non-SELECT statement is passed to the SQL property. This allows your end-users
  to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ...,
  ALTER ..., etc., without any additional processing. 
+ New properties are added to parenthesize conditions in WHERE clause.

See the full story for details

March 31, 2008

Active Query Builder ActiveX Edition v.1.9.0.9

+ DB2, MS SQL, SQL2003 dialects: Added support for field aliases for derived
  tables.
+ MySQL: Date/time and Extract functions are supported now.

March 25, 2008

Active Query Builder ActiveX Edition v.1.9.0.8

- Firebird: Fixed bug with incorrect prefix for stored procedure names.

March 21, 2008

Active Query Builder ActiveX Edition v.1.9.0.7

+ MS SQL: The new way to load list of available databases is added.

March 19, 2008

Active Query Builder ActiveX Edition v.1.9.0.5

- Fixed critical bug caused the component to generate wrong SQL query criteria
  in some cases (introduced in 1.9.0.2).

March 18, 2008

Active Query Builder ActiveX Edition v.1.9.0.4

* Chineese, Italian, German and Portuguese (Brazil) localizations files are
  updated. Spanish, Czech, Turkish and Japanese localization require updating.
  Please let us know if you can update one of them.
+ Two new events are added to update object metadata information if necessary: 
  QueryBuilder.OnObjectMetadataLoading(IMetadataContainer, IMetadataObject)
  QueryBuilder.OnObjectMetadataLoaded(IMetadataContainer, IMetadataObject)
+ The new QueryToLoadFields property is added to the IMetadataObject interface.
  Read this property to get SQL statement that should be executed to read
  result columns from dataset and fill the fields definition list for 
  this database object.
+ Now the Universal Syntax Provider is able to retrieve metadata from SQLite
  and Informix database servers.
+ MS SQL Syntax: Added support for the "OPENQUERY" clause.
- MySQL: Small fix is made in the loading relations procedure.
- Oracle: Small fix is made in loading objects procedure.
- Add Object Window: Fixed bug that does not allowed to add views and procedures
  to the query.

March 12, 2008

Active Query Builder ActiveX Edition v.1.9.0.2

+ The new boolean QueryBuilder.TreeOptionsMetadata.HideSingleDatabaseNode
  property is added to hide the database node from metadata objects tree when
  there is only one database is loaded to the metadata container.
- Fixed incorrect hiding of multiple database nodes.