Счётчик скачек MONERO
03085
Счётчик скачек MAGNETAR
0962

Active Query Builder Component Suite v1.7.9 Full Source

Ответить на тему
 
Автор Сообщение

star21 ®

Пол: Женский

Стаж: 11 лет

Сообщений: 262214

Откуда: Екатеринбург

Создавать темы 22-Апр-2016 07:35

[Цитировать]

Active Query Builder Component Suite v1.7.9 Full Source- Версия в раздаче: 1.7.9
Год выпуска: 03-27-2007
Разработчик: Active Database Software
Адрес официального сайта: http://www.activequerybuilder.com/index.html
Операционная система: Win All
Среда разработки: CBuilder & Delphi 5 - BDS 2007.
Таблетка: Не требуется (Full Source)Описание: Active Query Builder - это набор компонентов для Borland Delphi версий 6, 7 и 2005, а также Borland C++ Builder 6, который позволяет конечным пользователям Вашего приложения возможность построения сложных SQL запросов при помощи удобного визуального интерфейса. Интерфейс Active Query Builder подобен интерфейсу построителей запросов в MS Access или в SQL Server Enterprise Manager, но обладает гораздо большими возможностями. Мы понимаем, что мы не первые, кто пишет компоненты подобного рода, но наш компонент отличается тем, что позволяет визуально строить запросы с UNION'ами и подзапросами, а такого мы еще не встречали.

history

03-27-2007Version 1.7.9
*** Localization
- Chinese, Czech and Italian localizations are added.
*** SQL Parsing Engine
- Support of synonyms in Oracle is implemented.
- Join object hints in MS SQL Server are supported now: WITH (nolock, repeatableread, ...).
- MS SQL ranking and aggregate window functions and Oracle analytic functions are supported now.
- Sub-queries in WITH clause now have support of field's aliases.
- Parser Engine: More precise erroneous token reporting.
- Minor fixes in most of supported SQL dialects are made.
*** SQL Text Builder:
- Several bugs are fixed.
The new property is added to control format of the ORDER BY clause: ISQLBuilderSelectFormat.OrderByNewLineAfterEachItem.
*** Metadata Container:
- New properties are added for fields to be stored in the Metadata Container: Size (Integer), Precision (Integer), PrimaryKey (Boolean), Nullable (Boolean), ReadOnly (Boolean). They are filled according to database structure and can be saved to XML file.
*** Micsellaneous:
- The new (missing) properties are implemented to set width of the query structure tree: TreeOptions.TreeWidth.
- AbsoluteDB Metadata Provider is implemented.
- Several memory leaks are eliminated.
===============01-08-2007Version 1.7.7
- Added support for C++ Builder 5 IDE and BDS 2006 C++ Builder personality.
- Ability to convert queries between dialects is implemented.
- Spanish localization is added.
===============12-04-2006Version 1.7.5
- We have implemented retrieval of extended information about parameters. Now you can get table and field names to what this parameter will be applied. Also you can get the data type expected for this parameter. All these properties are available via the Parameters collection. Most of demo projects now have example of working with extended information about parameters.
- We have made the new QueryStatistics.OutputColumns property to get access to output columns of the query. It allows you to retrieve maximum information about output columns: - SQL Experssion and alias of expression, - Object name, Object alias and Field name (only if the column is based on single field).
- Better handling of the asterisk item in SELECT list: now the asterisk item (*) is added to a query by default and removed automatically when any other item is added to SELECT list.
- Multiple fixes and improvements for MS Access: Ability to retrieve linked tables is added, several fixes for MS Access sytnax are made, a form to manage MS Access query parameters is added (TOP, DISTINCT, etc.).
- The new AnsiQuotes property is added to MySQL Syntax provider in order to operate correctly with MySQL Server when the "ANSI_QUOTES" option is set or not. (ActiveX Editon works in default MySQL mode) Please refer to MySQL Documentation for more information: http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html
===============10-24-2006Version 1.7
- Database Objects Tree is implemented. The new TreeOptionsMetadata property is added to control layout and appearance of the newly created pane.
- Ability to localize the component is added. You can read more about it here: http://www.activequerybuilder.com/localizer.html
- Some visual improvements are made.
===============06-26-2006Version 1.6
- Storing metadata information in XML file. Storing and loading metadata information from an XML file makes loading metadata almost instant regardless of the number of objects being loaded. This also reduces the workload of the database server by making it unnecessary to request metadata from the server.
- Working in offline mode. Now Active Query Builder supports working in offline mode, loading metadata information from a previously saved XML file. This is very convenient if the component is used to work with a remote database, for example in the ASP.NET environment. In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance. In this case, the most convenient solution would be to work with Active Query Builder in offline mode.
===============06-26-2006Version 1.5.5
- Active SQL Parser has full Unicode support now. Please note that there are several properties to setup charset and other font properties of the TacQueryBuilder component to view your local symbols correctly: GridFont, TableFont and TreeFont.
- The new IdentCaseSens property is added to control the behavior of the ANSI syntax providers. This property determines whether an identifier should be quoted or not. The necessity to quote identifiers is a subject of naming conventions of specific database server. There are three possible values of this property: - icsNonSensitive: all identifiers are considered to be non-case sensitive. I.e. there will be no quoted identifiers except those which have special symbols like spaces. (MS SQL Server, MS Access, FoxPro) - icsSensitiveUpper: all identifiers are case sensitive and if an identifier is written with without quotes, it will be considered as ALL-UPPERCASE by the server. (Oracle, Informix, MySQL, InterBase, etc.) - icsSensitiveLower: all identifiers are case sensitive and if an identifier is written with without quotes, it will be considered as all-lowercase by the server. (PostgreSQL) Please note that this property is effective only for ANSI SQL/89 and SQL/92 standard dialects. For the rest of specific dialects this property is set automatically in accordance with naming conventions of the database server. You may find the IdentCaseSens property at the TacANSI92SyntaxProvider and TacANSI89SyntaxProvider classes.
- New metadata provider for the NexusDB database is added (www.nexusdb.com).
- Fixed bug with the Firebird syntax provider.
===============06-09-2006Version 1.5.3
- Ability to retrieve information about objects being used in the query is implemented. (Available in the Standard Edition only) The new QueryStatistics.UsedObjects collection is added to provide access to the list of database objects being used in the query.
- Ability to retrieve information about columns being used in the query is implemented. (Available in the Standard Edition only) The new QueryStatistics.UsedColumns collection is added to provide access to the list of columns being used in the query. To get only output columns of the query please check the Selected property of each collection item.
- We have changed the interface of the OnExecSQL event of TacEventMetadataProvider due to incompatibility of the previous interface with C++ Builder. TacExecSQLEvent = procedure(Sender: TacBaseMetadataProvider; SQL: WideString; var ADataset: TDataset) of object;
- Now you can load queries containing incorrect database objects.
===============05-10-2006Version 1.5
- Ability to to work with metadata is implemented. The new MetadataContainer property is added to provide access to the list of metadata objects used in the component. With its help, you can add or remove items manually to restrict certain tables being displayed in the component or you may even fill the entire metadata container by yourself to avoid connecting to the database. The MetadataContainer property is a collection of metadata objects. You may iterate through the loaded metadata objects, add or remove them.
- Ability to build queries with objects from different databases is implemented. You are able to load additional metadata information from another databases by using the LoadMetadataByMask method of the MetadataContainer collection. The first two parameters are the masks for object names and schemas respectively. The third parameter is the database name from which you want to load metadata. If you don't want to filter objects loaded by name or schema, you should use the "%" symbol for the first two parameters. These parameters will be applied to the metadata retrieving query using the LIKE operator.
- Pre-filtering of database objects is implemented to speed up metadata loading process. The new MetadataFilter property is added to implement (pre)filtration of database objects. This feature can speedup metadata loading process dramatically if there is a huge number of tables in the database and only a small set of them is operated with. The MetadataFilter property is a collection of metadata filter items. Each item specifies one inclusion or exclusion condition that can affect specific object types (tables, views or procedures) and filter objects by object name and schema name using masks. You may use "_" to represent any single character and "%" to represent any sequence of characters.
- We have created the User's guide for end-users of Active Query Builder. You may include it into your help files freely.
- Most memory leaks have been eliminated.
- Connecting to the database using old OLE DB providers that do not support foreign keys resulted in error. Fixed.
===============03-22-2006Version 1.4.5
- TacQueryBuilder: The new MetadataPrefilter property is added to implement pre-filtration of database objects. This feature can decrease metadata loading time dramatically in case of huge number of tables in the database when only a small set of them is required to operate with. The MetadataPrefilter.ExcludedSchemas string list should contain names or masks of schemas to be excluded from the list of database objects and the MetadataPrefilter.IncludedSchemas should contain names or masks of schemas to be included in the list of database objects. Actually these properties will add some constraints to the WHERE clause of all metadata retrieving queries, i.e. each line in the IncludedSchemas list will add the 'LIKE' clause while each line in the ExcludedSchemas list will add the 'NOT LIKE' clause.
- TacQueryBuilder: The new Parameters property is added to retrieve the list of parameters. Use the Parameters.Count property to get the number of parameters in the query and the Items property to get access to each parameter in the query.
- TacQueryBuilder: The new GridFont, TableFont and TreeFont properties are added to change fonts (and their charsets) used in each part of the TacQueryBuilder component.
- New metadata provider for the Advantage database system is added (www.advantagedatabase.com).
- New metadata provider for the IB Objects is added (www.ibobjects.com).
- ANSI-quotation is implemented in the MySQL Syntax provider.
- Other minor bugfixes and improvements.
===============03-03-2006Version 1.4.1
- MS Access SQL dialect is supported now.
- Several minor bugs are fixed.
===============02-01-2006Version 1.4.0
- New metadata provider for the DBISAM embedded database engine is added (http://www.elevatesoft.com/prodinfo.htm).
- New metadata provider for the SQLDirect BDE replacement component library is added (http://www.sqldirect-soft.com/).
- New metadata provider for the Core Lab SQL Server DAC is added (http://www.crlab.com/sdac).
- TacQueryBuilder: The new Clear method is added to empty currently builded SQL query at a time.
- TacQueryBuilder.AddObjectFormOptions: New properties are added to hide tabs of the Add Object Window (TablesVisible, ViewsVisible, ProceduresVisible).
- TacQueryBuilder: The new ColumnWidthExpression property is added to define initial width of columns in the Columns pane.
- Other minor bugfixes and improvements.
===============01-22-2006Version 1.3.9
- Support of MySQL spatial and enum/set data types.
- Improved support of correlated sub-queries.
- Final fixes in the Oracle SQL dialect.
- Multiple fixes and improvements for different SQL dialects.
- Internal redesign and improvements in the base AST classes.
- Other minor bugfixes.
===============01-02-2006Version 1.3.5
- Delphi 2006 is supported now.
- Some issues in handling of case sensitive indentifiers are fixed.
- Some bugfixes and improvements in Oracle, Firebird and InterBase SQL dialects.
===============12-26-2005Version 1.3.0
- Informix SQL dialect is supported now.
- ANSI SQL/89 dialect is supported now.
- New metadata provider for the Luxena Informix Data Access Components is added (http://www.luxena.com/products.aspx?product=idac).
- New metadata providers for the MicroOLAP Data Access Components for MySQL and PostgreSQL are added (http://microolap.com/products/connectivity/).
- Correct handling of case sensitive identifiers is implemented.
- The interface of the OnGetFields event is changed: --- TacGetSQLFieldNamesEvent = procedure( Sender: TacBaseMetadataProvider; const ASQL: String; AFields: TacFieldsList) of object; --- This change allows you to pass WideString field names as well as to store case sensitive field names.
- TacQueryBuilder, TacSQLBuilderPlainText: The new QuoteAllIdentifiers property is added. Setting them to True you'll get all identifiers in the query quoted.
The TacQueryBuilder.QuoteAllIdentifiers is responsible for internal Query Builder quotation and the TacSQLBuilderPlainText.QuoteAllIdentifiers is intended to quote identifiers in result SQL code.
- Many bugfixes in Oracle, Firebird and InterBase SQL dialects.
- Minor interface improvements.
===============12-05-2005Version 1.2.0
- Fixed bug with joining tables for the Oracle 8i.
- New metadata provider for the AidAim Accuracer is added (www.accuracer.com).
- New metadata provider for the AidAim EasyTable is added (www.aidaim.com).
- All metadata providers are moved out from the main package.
- Fixed bug with empty schema name in ADO (MS Access "".tablename bug).
- Now Add Object Window allows to filter database objects by schema.
- TacBaseSQLBuilder: The new KeywordFormat property is added to define case of SQL keywords (akfFirstUpper, akfUpperCase, akfLowerCase).
- Added support for the "UNKNOWN" logical constant for the SQL Server 2005.
- Added support for C-style comments /* ... */ to the ANSI-92 SQL dialect.
- InterBase and Firebird dialects were separeted from each other.
- Fixed bug with unability to create unions and sub-queries using InterBase and Firebird syntax providers.
- Fixed bug with indentation in InterBase, Firebird and MySQL SQL dialects.
- Other minor improvements.
===============11-21-2005Version 1.1.5
- New metadata provider for Allround Automations Direct Oracle Access components added (www.allroundautomations.nl/doa.html).
- New metadata provider for Fast InterBase Plus (FIBPlus) components (www.devrace.com/en/fibplus).
- Added optimization of arrangement of tables within the FROM clause to avoid CROSS JOINs.
- New events added for database objects filtering to work only with required objects.
- Improved mechanism of database objects quotation.
- Metadata caching implemented.
- Fixed bugs with MS SQL Server syntax provider.
===============09-27-2005Version 1.1.1
- Fixed bugs in the SQL Server dialect: now queries with comments and the Convert function are parsed correctly.
- Now all object in metadata providers are stored with quotation.
! Please note that using the generic event-driven metadata provider you should provide all object names with right quotation.
===============09-24-2005Version 1.1
- Oracle dialect supported (versions from 7 to 10) (TacOracleSyntaxProvider)
- New metadata provider for Core Lab Oracle DAC added (http://www.crlab.com/odac).
- New metadata provider for Core Lab MySQL DAC added (http://www.crlab.com/mydac).
- Added optimization of arrangement of tables within the FROM clause to avoid CROSS JOINs
- Fixed bug with wrong quotation of SQL Server function names
- MySQL InnoDB tables weren't linked automatically. Fixed now
===============09-28-2005Version 1.0
After more than two months of beta testing we have releasedActive Query Builder Component Suite version 1.0.0.
Thanks to everybody who helped us to make it happen!
===============09-26-2005Version 0.9.9.9
- InterBase/Firebird dialect supported (TacIBSyntaxProvider)
- Significant improvements in the parsing engine. Amount of memory used for parsing of large queries was decreased dramatically.
- New metadata provider for ibExpress added (TacQBIBExMetadataProvider).
- New metadata provider for dbExpress added (TacQBdbExMetadataProvider).
- Full duplex syncronization implemented between object nodes selection in the tree and objects in the qurey builder working area.
- Fixed bug with resizing of the Add Object Form.
- Fixed bug with quotation of the names of aggregate functions.
- Fixed bug with quotation of CONTAINS, CONTAINSTABLE, FREETEXT, FREETEXTTABLE keywords for MS SQL Server dialect.
===============09-20-2005Version 0.9.9.5
- SQLite dialect supported (TacSQLiteSyntaxProvider).
- MS SQL Enterprise Manager style link painter implemented.
- MS Access Link Painter: The new MarkStyle property is added to determine visual displaying of JOIN kinds. Now you can use MS SQL Enterprise Manager displaying of JOIN kinds combined with MS Access links painting style.
- The IndentGlobal property was moved from the TSQLBuilder component to the TSQLBuilderSelectFormat component to define global indents in subqueries.
- TacQueryBuilder: The new UseTableIcons property is added to display an icon in the header of objects depending on object style.
- TacQueryBuilder: The new DefaultTableWidth property is added to alter default object width when added to the query builder.
- New button is added to the header of objects to collapse them to the minimal height.
- New button is added to the header of subquery objects to jump to their visual building area tab.
- New "Add New SubQuery" menu item is added to the columns pane inline editor popup menu.
- New "Autofit object height" menu item is added to the objects popup menu.
- New menu items are added to the columns pane rows popup menu to move rows up and down.
- New menu items are added to the unions panel popup menu to move subqueries and brackets forward and backward.
- Fixed errors with SQL Builder output formatting of query text.
- Fixed bug with clearing contents of Criteria field of columns pane in case of incorrect expression entered by user.
- Several critical errors fixed.
===============09-13-2005Version 0.9.9
- New ability is added to work with stored procedures and functions in TacBaseSyntaxProvider.
- TacQueryBuilder: New methods are added to retrieve lists of tables, views and procedures to support server specific rules of retrieval. For example, to retrieve a list of tables for MS SQL Server, 'exec sp_tables' is executed now. You should use these methods instead of appropriate TacBaseMetadataProvider methods. Methods of TacBaseMetadataProvider remain unchanged, but they are obsolete now.
- New OnGetProcedureNames event is added to the TacEventMetadataProvider component.
- TSQLBuilderConditionFormat: The new IndentNestedConditions property is added to specify an indent for nested conditions.
- TSQLBuilderFromClauseFormat: The new JoinConditionFormat property of the TSQLBuilderConditionFormat type is added to determine the layout of JOIN conditions.
- TSQLBuilderConditionFormat: The new NewLineAfter property is added to split logical expressions by lines. Now you can start new lines in the following cases: - After top-most OR operators; - After all top-most logical operators; - After all logical operators.
- TacQueryBuilder: The new LinkPainterClass public property is added to change link painting style programmatically.
- The TacBaseSyntaxProvider component is moved to the acAST.pas module and merged with the TastBaseSyntaxProvider component.
!!! Attention !!!acMYSQLAST, acMSSQLAST and acPGSQLAST modules are removed, useacMYSQLSynProvider, acMSSQLSynProvider and acPGSQLSynProvider modules instead.
===============08-30-2005Version 0.9.8
- We have released detailed help system!
- Query Tree Pane implemented. Now you can see the whole query structure at one sight!
- TacBaseSQLBuilder has been upgraded dramatically: Many new options implemented to format of SQL query text as you wish.
- TacQueryBuilder. We added the new property VisibleColumnsPane allowing you to show/hide query builder columns pane.
- We have implemented a new way of object names quotation. Now quotation is applied only when building SQL query text.
- TacQueryBuilder. We added the new property SyncSQL that allows you to provide immediate update of internal query builder objects as well as SQL query text generated by attached SQL builder components.
- TacOnSQLError. New parameters are added to locate erroneous token of SQL statement more precisely.
- TacDatasourceObject. The ObjectName property has been renamed to DatabaseObject.
- The acAbout unit has been renamed to acQBAbout to avoid conflicts with AppControls components.
===============08-19-2005Version 0.9.7
- PostgreSQL dialect supported.
- new Generic Event-driven Metadata Provider added.
- Significant improvements in all SQL syntax providers.
- TacSelectList: AddExpression and InsertExpression methods implemented to add any arbitrary expression to the select list.
- TacQueryBuilder.AddObjectFormOptions: New properties added: Constraints, Height and Width.
- Classes named Tast*MetadataProvider were removed, TacBaseMetadataProvider class was moved to acAST.pas module.
- Fixed bug with unavailability of forms for editing tables and relationships for ANSI-92 SQL dialect.
- In some cases while working with parenthetic unions, sending of notification messages was hanged. Fixed now.
- A lot of minor improvements and bugfixes.
===============08-02-2005Version 0.9.5
- New metadata provider for Zeos Database Objects (http://sourceforge.net/projects/zeoslib/): TacQBZeosMetadataProvider
- New metadata provider for Borland Database Engine: TacQBBDEMetadataProvider
- TacQueryBuilder: Added complex property AddObjectFormOptions that allows you to setup Add Object Dialog Form easily.
- TacBaseMetadataProvider: Method GetObjectNames replaced with two new methods: GetTableNames and GetViewNames.
- Now all the database object names comparisons are performed in syntax providers.
===============07-26-2005Version 0.9.3
- TacQueryBuilder: Added property DefColumnsPaneHeight - defines columns pane height. Default value - 0, set automaticaly, 3/8 from the whole height.
- TacQueryBuilder: Added event OnGetTabHeaderText - triggers when assigning caption to a subquery tab. Write an OnGetTabHeaderText event handler to provide your custom subquery caption.
- TacQueryBuilder: Added event OnSQLError - triggers on SQL parsing error.
- TacQueryBuilder: Added propertied BorderStyle, BorderWidth, BorderColor used for customization of Query Builder appearance.
- TacQueryBuilder: Now painting links incapsulated in separate classes derived from TacQueryBuilderLinkPainter.
- New visual style: MS Access Style - used by default
- TacQueryBuilder: Added properties TabHotTrack, TabStyle used for customization of subquery Tabs.
- TacMySQLSyntaxProvider: Property ServerVersion is of string type now. Integer value moved to public property ServerVersionInt.
- Fixed bug with scrolling on changing focus to partially visible table.
- Now it is impossible to move table above the scrollable visual area.
- Now you can't link fields of one table with each other.
================================================================================07-14-2005Version 0.9.1
First public beta version

screenshots

[Профиль] [ЛС]
Показать сообщения:    
Ответить на тему

Текущее время: 22-Ноя 22:49

Часовой пояс: UTC + 5



Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете голосовать в опросах
Вы не можете прикреплять файлы к сообщениям
Вы не можете скачивать файлы