Downloads

Active Query Builder History History

March 11, 2009

Active Query Builder History 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. 

March 11, 2009

Active Query Builder History v.1.11.7.0

= Fields loading is disabled on calling the SaveToXMLFile method in the Offline
  mode (WorkOffline property is True).
- 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.

March 10, 2009

Active Query Builder History v.1.8.5.163

- Oracle: query builder now loads only metadata objects with granted SELECT right.
- Bug with SubString function is fixed.

March 05, 2009

Active Query Builder History v.1.8.5.162

+ New events are added to control adding of new expressions from the query
  building area (by clicking a checkbox, double-clicking a field or gragging 
  them to the grid): DatasourceFieldAdding, DatasourceFieldAdded.
+ Demonstration of DatasourceFieldAdding is added in the Events Demo.
= On saving metadata to XML file in Offline mode, the query builder does not
  try to load missing object columns from database now. This allows to cache
  database objects without their fields in XML file.
+ Metadata caching example is added to the Full Featured Demo project.

February 27, 2009

Active Query Builder History 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 27, 2009

Active Query Builder History v.1.11.5.0

+ MS Access: Support of "SELECT INTO" clause is added.
+ The new IActiveQueryBuilderX.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: IMetadataRelation.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 25, 2009

Active Query Builder History v.1.8.4.159

+ The new DenyIntoClause property is added to MSAccessSyntaxProvider, 
  MSSQLSyntaxProvider and MySQLSyntaxProvider to allow/deny usage of the INTO
  clause in SQL queries.
+ The LoadMetadataDemo is modified. Demonstration of loading metadata from a 
  stored DataSet is added.
+ Visual Basic version of the FullFeaturedMdiDemo is added.
+ New property StatisticsOutputColumn.MetadataObject is added.
= Now you can invoke the Query Properties dialog with double click on the
  diagram pane (this was possible only through the context menu only).
- Minor memory leaks are fixed.

February 04, 2009

Active Query Builder History 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.

February 04, 2009

Active Query Builder History v.1.11.0.0

+ 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:
  IActiveQueryBuilderX.FieldsListOptions.KeyFieldsFirst: VARIANT_BOOL.
+ 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.

January 30, 2009

Active Query Builder History v.1.8.2.155

+ Now you can drag and drop fields from datasource objects right onto the
  criteria list (grid).
+ Double click on a datasource field adds it to the criteria list now.
- Oracle syntax: Wrong loading of some WHERE constructions is fixed.