Downloads

Active Query Builder VCL Edition History

April 21, 2008

Active Query Builder VCL Edition v.1.9.0.21

+ New properties are added to the TacQueryBuilder.TreeOptionsMetadata to change
  captions for database object type grouping nodes: TablesNodeName,
  ViewsNodeName, ProceduresNodeName, SynonymsNodeName :WideString;
- 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 VCL 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 VCL Edition v.1.9.0.16

+ The new metadata provider is added for the CoreLab Interbase DAC package
  (https://www.crlab.com/ibdac): TacCrIbDACMetadataProvider.
+ 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.
- Fixed problem with derived table field's aliases.

March 31, 2008

Active Query Builder VCL Edition v.1.9.0.9

+ 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.
+ DB2, MS SQL, SQL2003 dialects: Added support for field aliases for derived
  tables.
+ MySQL: Date/time and Extract functions are supported now.

See the full story for details

March 25, 2008

Active Query Builder VCL Edition v.1.9.0.8

- Firebird: Fixed bug with incorrect prefix for stored procedure names.
+ TMS Unicode controls are supported now.
+ The new TacQueryBuilder.OnActiveSubQueryChanged is added.

March 21, 2008

Active Query Builder VCL Edition v.1.9.0.7

+ The new demo is added to illustrate ability to replace real object and field 
  names with user-friendly alternate names (Demos\AlternateNames).
+ MS SQL: The new way to load list of available databases is added.
+ Demo projects are updated to show new settings dialog for the Universal syntax
  provider.
* New properties are added to the Universal syntax provider:
  AutoDetectServer: Boolean; allow/deny database server autodetection. 
  PreferredServer: TacUniversalSyntaxServerType; defines database server to
  start the autodetection routine from.
  UsedServer: TacUniversalSyntaxServerType; determines detected database server.

March 19, 2008

Active Query Builder VCL 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 VCL Edition v.1.9.0.4

 	
+ Tne new demo project is added to illustrate ability to modify queries
  programmatically (Demos\QueryModificationDemo).
* Chinese, 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: 
  OnObjectMetadataLoading(TacMetadataContainer, TacMetadataObject);
  OnObjectMetadataLoaded(TacMetadataContainer, TacMetadataObject);
+ The new QueryToLoadFields property is added to the TacMetadataObject
  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.
+ TacUniversalSyntaxProvider: The new AutodetectConnectedServer(ASQLContext) 
  method is added to re-detect connected server manually
+ Localizer: Ability to load localized strings through the event is implemented
+ 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 VCL Edition v.1.9.0.2

- Fixed packages for C++ Builder 5 and 6.
- Fixed incorrect hiding of multiple database nodes when HideSingleDatabaseNode
  property is turned on.

March 05, 2008

Active Query Builder VCL Edition v.1.9.0.1

+ The new Universal Syntax Provider is added to the Free version. 
  It is based on the ANSI SQL/92 syntax but allows to determine most of popular
  database servers, successfully retrieve metadata and apply specific settings
  for them to let the user build simple queries for these servers.
  Please note that this does not mean that the Universal Syntax Provider could
  be a suitable replacement for specific database syntax providers, as it
  strictly follows the rules of ANSI standard, that may lead to many 
  incompatibilities while working with specific database servers. 
  Working with the Standard version, use the Auto Syntax Provider in case of
  necessity to detect database server automatically.  
* ANSI SQL/92 Syntax Provider has been removed from the Free version.
* Most of the demo projects are modified to work with Universal Syntax Provider
  by default.
+ PostgreSQL query properties form is added.
- PostgreSQL syntax: Fixed problem with double VARCHAR generation for 
  built-in types.
- PostgreSQL syntax: Added support for "/* ... */" comments that were
  erroneously parsed as user-defined operators "/*" and "/*".
- DB2 Syntax now treats "@" and "#" as valid identifier characters.