IBProvider v1.6.3.213

Updates

1. Support of «execute procedure SP» queries without definition of parameter list. In the case of the preparation of such query, provider singly will determine the number of IN-parameters and transform the query into «execute procedure SP(?)»

2. New parameter of initialization of data source and command — «force_prepare_stmt«. This provides forced preparation of query and obtaining the descriptions of the parameters at the definition of the query text. By default it is turned off (false).

3. Optimization of work with the parametrized queries from ADODB. Now the productivity of the query executing from ADODB is equivalent to interaction with provider directly through OLE DB interfaces.

4. Support of ODBC statements in the text of query is extended:

• «{call SP(?,?,?)}» — call-in of the stored procedure («select * from SP(?,?,?)»)
• «{oj …}» — JOIN clause

5. Error with the automatic forming of the description of the parameters of query is corrected. The dual call of ADODB.Command.Parameters.Refresh led to cleaning of the descriptions list.

6. The control of the definition of the string parameters of queries is weakened. If client does not indicate the length of string, then its length is determined by the completing zero character. This will gladden users of ATL OLEDB, in which the length of the string parameters is not passed.

Usage of IBPoivider as provider of «Crystal Reports» data source

Now this support is made a more complete. Main thing is not to forget to indicate in the connection string parameter «support_odbc_query=true».