Downloads

Active Query Builder VCL Edition History

October 06, 2009

Active Query Builder VCL Edition v.1.13.19.0

+ SQLite: The query properties form is made to define LIMIT, etc.
+ SQLite: The component now can fetch metadata from "attached" databases
- SQLite: LIMIT support in the main query is fixed.
- SQL dialects without databases support (like Oracle) didn't skip default
  schema from object names. Fixed now.
+ Oracle: Fetching user comments for objects and fields into LongDescription 
  is made.
+ Improved processing of user input in Criteria cells. Now strings like "like
  qwe qwe" will be translated to "like 'qwe qwe'".
+ MS SQL Server: DatePart, DateName, DateDiff, DateAdd builtin functions
  support is made.
- Oracle: Parsing of the SEED keyword is fixed.
+ The new TacMSAccessSyntaxProvider.LoadQueriesWithParameters property is made
  for flagging metadata loader to get queries with parameters into metadata
  container as stored procedures (they still can not be used in SELECT queries,
  so you need to handle these objects in specific way, not using AQB).
+ The new TacMSAccessSyntaxProvider.LoadLinkedTables property is made to
  control loading of linked database objects into metadata container.
+ The new helper functions are added to the TacBaseSQLContext object for
  splitting full name by parts: ExtractNameFromFullName,
  ExtractSchemaFromFullName, ExtractDatabaseFromFullName.
- Oracle: Recursive query format is fixed now.
- MS SQL: Most type names can be used are valid identifiers now.
+ The new set of helpers are added to the Metadata Container to add objects by
  their full or partially qualified names: AddObject, AddTable, AddView,
  AddProcedure, AddSynonym.
+ The new properties are made to control case sensitivity of metadata filter
  items: TacMetadataFilterItem.SchemaMaskCaseSensitive and
  TacMetadataFilterItem.ObjectMaskCaseSensitive.
+ The new events are added to control unchecking of a field from the datasource
  field list: OnDatasourceFieldRemoving and OnDatasourceFieldRemoved.
+ The new properties are made to force the query builder to show or omit the AS
  keyword in alias definition. Use the TacQueryBuilder and TacBaseSQLBuilder 
  AsKeywordInExpressionAlias and AsKeywordInObjectAlias properties for this
  purpose.
- Some small fixes are made for custom aggregate functions support.
- Subtle AV on closing control is fixed.
- Localizer fixed for RAD Studio 2009 and higher.

September 04, 2009

Active Query Builder VCL Edition v.1.13.10.0

+ Installer: C++ Builder 2010 support is fixed.
+ Installer: DevExpress ExpressSkins and QuantumTreeList versio auto detection
  and automatic sources configuration is made.
- DevExpress ExpressSkins and QuantumTreeList 4 support is fixed.
+ Oracle and PostgreSQL: interval literals support is added.
+ Custom Aggregate Functions support is made.
+ MS SQL Server: Custom aggregate functions fetching is made.
+ The INNER keyword can be omitted now in join specifications for Firebird,
  Interbase and MS SQL Server via the InnerKeywordInLinks property.
= NexusDB connectivity package is upgraded to 3.01.
= DBISAM connectivity package upgraded to 4.28.
= Refactoring: TacMetadataFieldNamesList is renamed to 
  TacMetadataQualifiedNamesList.
- CROSS JOIN processing bug is fixed.
- LoadMetadataDemo and QueryModificationDemo are fixed for RAD Studio 2010.
- Access violation when user delete a table which used in a correlated query 
  is fixed.
- The "NULLS FIRST" and "NULLS LAST" ordering options representation is fixed
  in grid.
- Access violation in Delphi 5-7 when loading SQL in OnExit event of SQL edit
  is fixed.

August 03, 2009

Active Query Builder VCL Edition v.1.13.0.0

+ Embarcadero RAD Studio 2010 is supported now.
+ Firebird 2.5 support is added.
+ Support of QuantumTreeList 5 is added, QuantumTreeList 4 is dropped
  (for DevExpress v.45 and higher)
+ The new property InnerKeywordInLinks is added to TacSQLBuilder and
  TacQueryBuilder components to suppress the "INNER" keyword in joins.
- InterBase/Firebird: Fixed identifiers validity checks.
- Sybase ASE support is fixed.
- Parsing of highly parenthesized WHERE joins is fixed.
- Right quotation in "Alias" column is made.
- Right interpretation on writing the "='" and "'" strings in condition cell.
- MS SQL: NULLIF function support is fixed.
- PostgreSQL: SIMILAR TO operator support is fixed.
- PostgreSQL: Escaped and unicode string literals support
- MS SQL: Default database name querying under RemObjects DataAbstract is fixed.
- Showing of the Query Properties dialog is fixed with Auto Syntax Provider.
+ RemObjects DataAbstract integration is updated.
- Support of ElevateDB2 is fixed.

June 26, 2009

Active Query Builder VCL Edition v.1.12.6.0

+ SQL 2003 syntax provider: minor updates are made.
+ The new property is added to allow visual setting of NULLS FIRST/NULLS LAST 
  options: TacQueryBuilder.SelectListOptions.ShowNullOrderingInSortTypeColumn.
- Fixed: "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart.
- PostgreSQL: Bug in parsing of INTO clause is fixed.
+ Oracle: &-style parameters support is added.

May 28, 2009

Active Query Builder VCL Edition v.1.12.2.0

+ Fetching of precision and scale for field types from OLE DB providers is 
  possible now.
+ Displaying of precision and scale for variable-precision data types (decimal
  and numeric) is made.
- Add New Object dialog: Objects filtration by database and schema is fixed.
- The bug that leaded to exponential grow of parsing time for some FROM clauses
  is fixed.
- MS SQL Server: RIGHT is a keyword, it can be used only as join specification
  and built-in function.
- DB2: national encoded string literals are parsed correctly now.
- DB2, Oracle: Fetching of scale for numeric fields is fixed.
- PostgreSQL: "Interval" type support is fixed.

May 15, 2009

Active Query Builder VCL Edition v.1.11.20.0

+ Now the user can edit Join expression maually via the Link Properties dialog.
+ DB2, PostgreSQL and ANSI SQL/92: "NULLS FIRST/LAST" support is added.
+ PostgreSQL: Support of INTO clause is added.
+ The internal visual controls destroying method is changed. Now all 
  differences between SQL and SyncSQL properties are eliminated.
+ MS SQL: loading synonyms info for MS SQL 2005 is made.
= The component produce an empty query string on empty query builder now.
+ The new menu item is added to the Union Sub-Query context menu to copy the
  current union sub query to a new one.
+ DB2: CONCAT operator is supported now.
+ Metadata XML schema is updated.
= MS SQL Server: The '=true' and '=false' values are treated now as special
  comparisons for logical expressions only.
+ Now it is possible to change join type via context popup menu.
= Right quotation of conditions in the grid is made.
- MySQL: Missing "QUARTER" and "WEEK" functions are added.
- MS Access: Quoted parameters parsing is fixed.
- InterBase/Firebird: Empty brackets are suppressed now for stored procedures
  in the FROM clause.
+ Field descriptions are loaded into metadata container from OLE DB Provider.
- Fixed bug with assertion failure when link condition contains sub query.
+ The User's Guide is updated.
+ More optimal grid filling is made when loading criteria and select list items.
= The "Move forward" and "Move backward" Union Sub-Query context menu items are
  renamed to the "Move left" and "Move right" for better understanding.

April 06, 2009

Active Query Builder VCL Edition v.1.11.12.0

+ DB2 Syntax: Query Properties dialog is added.
+ MS SQL Server: Ranking functions are supported now.
- The bug with syntax provider switching is fixed.
- Metadata filters are working fine for Oracle now.
- Firebird: support for "NULLS FIRST" and "NULLS LAST" is added.
+ A number of small fixes in installer are made.
+ Nexus DB v3.00 connectivity package is added.
- TNT controls compilation fixes are applied.
- Advantage connectivity package is fixed.

March 11, 2009

Active Query Builder VCL Edition v.1.11.7.0

+ Two new events are added to control fields adding from the query building
  area to expressions grid: TacQueryBuilder.OnDatasourceFieldAdding and
  TacQueryBuilder.OnDatasourceFieldAdded.
= Fields loading is disabled on calling the SaveToXMLFile method in the Offline
  mode (WorkOffline property is True).
+ Full Featured Demo: Code example of caching metadata using XML files is added.
- Fixed bug with the Substring(_FromString From _Index For _Count) function
  for many SQL dialects.
= Oracle syntax: Now showing only those database objects that allowed for
  selection. 

February 27, 2009

Active Query Builder VCL Edition v.1.11.5.0

+ The new TacOutputColumn.MetadataObject property is added to get access to the
  database object of output field. 
+ All links to database objects and fields point directly to objects of 
  Metadata container, not to their copies.
+ MS Access: Support of "SELECT INTO" clause is added.
+ The new TacBaseSyntaxProvider.DenyIntoClause property is added to restrict
  building of SQL queries containing "SELECT INTO" clause.
+ Two new properties are added to define cardinality of relations between
  database objects: TacMetadataRelation.KeyCardinality and ChildCardinality.
- The "BETWEEN" operator is now treated as logical for better handling of
  manual criteria input.
- MS Access: Usability fixes in conditions parser are made.

February 04, 2009

Active Query Builder VCL Edition v.1.11.0.0

+ DevArt PostgreSQL DAC connectivity is added.
+ New sample project is added. The EventsDemo demonstrates using of few useful
  events to get control over the query building process.
+ Double click on a datasource field adds it to the criteria list now.
* Drag and drop fields from datasources to the select list is reactivated now.
+ Preservation of additional ORDER BY clause is made (like Oracle's NULLS FIRST)
+ The new property is made to move key fields at the top of fields list
  regardless of fields sorting:
  TacQueryBuilder.FieldsListOptions.KeyFieldsFirst: Boolean;
+ Built-in search in datasource field lists at the query building area is 
  reactivated.
- Oracle: MONTH, DAY, HOUR, MINUTE words are to the list of valid identifiers.
- Oracle: Wrong loading of some WHERE constructions is fixed.
+ Minor painting improvements of the datasource field lists is made.
+ Numeric condition values for string fields are quoted automatically now.
- MySQL: REPLACE function is supported now.
- WideString to AnsiString translation and other localizer fixes are made.