IBProvider v3.8. UDF in metadata schemas. Configuring of transaction isolation parameters. New "Free"

User Defined Functions in metadata schemas.

• The provider publishes data about UDF in PROCEDURES and PROCEDURE_PARAMETERS schemas.
• The column [PROCEDURES].[PROCEDURE_DEFINITION] contains the text with UDF declarations — «DECLARE EXTERNAL FUNCTION …».
• The provider supports the all FB/IB versions and Yaffil. Including — Firebird 3.0 (ODS 12.0).

Configuring of transaction isolation levels.

Now you can configure the parameters for supported isolation levels: read_committed, repeatable_read и serializable. For these purposes were defined the new initialization properties: ib_tr_params__read_committed, ib_tr_params__repeatable_read, ib_tr_params__serializable.

The provider supports next tags: read, write, wait, nowait, rec_version, no_rec_version, read_committed, concurrency, consistency.

Important changes

• Transaction parameters
  
  

  Isolation	Old parameters	New parameters
  Read Committed	write read_committed no_rec_version wait	write read_committed rec_version nowait
  Repeatable Read	write concurrency wait	write concurrency nowait
  Serializable	write consistency wait	write consistency nowait

  
  
• The support for isolation level CHAOS was removed.
• The support for ISOLATIONLEVEL_UNSPECIFIED was removed.

The support for SQL_BIT in ODBC function CONVERT.

• When you work with FB3, IB7+, the statement «{fn CONVERT(value, SQL_BIT)}» will be transformed into «CAST((value) AS BOOLEAN)».

New runtime of Visual Studio 2008.

• The new provider uses a new runtime of Visual Studio 2008 — 9.0.30729.5570.

New Free IBProvider v3.8.

• All last changes from IBProvider Professional Edition.
• Added the support of Firebird 2.1.