IBProvider 1.7.6.350 and 1.8.0.350 beta

Updates in the provider

• Property of initialization and command "named_param_prefix". This property determines prefix of the named parameters in the query text. Default value is ":". Provider supports prefixes, which consist of several characters, for example, "##". The characters of prefix can be any. If you set empty string into "named_param_prefix", then provider will not support named parameters. This functionality is necessary with the executing of DDL queries.
• Now COM+ transactions use isolation level indicated in the property of the initialization of the data source "auto_commit_level". Focus your attention, that after connection you can change isolation level through "Autocommit Isolation Levels" property. From a technical point of view, COM+ transactions use the isolation level ISOLATIONLEVEL_UNSPECIFIED.

  By default "auto_commit_level" determines SNAPSHOT isolation level.

  If you put "auto_commit_level" in -1 (ISOLATIONLEVEL_UNSPECIFIED), then SNAPSHOT isolation level will be used.

• Work with BSTR data type is changed. Some OLEDB-clients cannot interpret NULL as empty string. Therefore now IBProvider returns the available pointer to the empty string. The symmetrical problem is corrected in the client library - NULL-equaled BSTR is not passed to OLEDB providers.
• The type of rowset bookmarks is changed. Now bookmarks are of DBTYPE_BYTES type and have unfixed length. Maximum size is 4 bytes.

Updates in client library

• t_db_cursor Complete support of the bi-directional data selection and navigation on the rowset.
• t_db_open_rowset New class for the opening of tables through the interface IOpenRowset
• t_db_open_schema_rowset New class for opening of sets of information schema (IDBSchemaRowset interface)

Let us note again that the library is supplied in source code and uses the type converter common with IBProvider, i.e. if IBProvider can work with 52 types of data, then client library can make this too.

You can yourself estimate the cost of the equivalent libraries, after looking the division of references on our site.

Beta version 1.8

The basic purpose of version 1.8 is the implementation of the interfaces of the modification of the results of queries. In this case the foregoing mechanisms optimized for the read-only mode will remain in the provider. It are tested completely and do not cause any claims.

Nevertheless, there are the global changes in provider, which can disrupt the work of your applications. Therefore we imperatively recommend not to put aside functional test of beta 1.8 in your applications. If only you do not plan to remain to 1.7 after release of 1.8.

Focus your attention, during the registration DLL beta 1.8 and 1.7 mutually exclude each other. Therefore only one of these versions can be registered in the system.

The registered users can appeal to obtain limit-free beta-version.

Updates

• The maximum size of the bookmarks is 8 bytes. Server cursor mode ceased to work in ADOExpresse. It is possible, entire matter is in the realization of OleVariant. We tested ADOAnywhere and ADOExpress from BCB5. If you have a possibility to do tests with Delphi and BCB6, please, report to us about the results. When working with ADODB directly such problems were not discovered.
• For tests, IOpenRowset will return the new realization of rowsets. At present this is the valuable and thoroughly tested replacement of foregoing read-only mechanism, and it is intended for the running-in of the new manager of rowsets.