Publish date: 2010-09-16

Implementation of IRowsetBookmark interface. Fixed a support of case-dependent names of database objects in schemas

Processing of errors has been corrected

In the previous IBProvider versions, error information could be lost and null symbols used to get to the text. Now fixed.

IRowsetBookmark interface has been implemented

It allows rowsets to use bookmarks to sequential cursor.

The algorithm for working with symbol cases in database object names has been improved

In the third dialect of Firebird/InterBase database, both upper and lower case letters can be used in names. Notably, a database can simultaneously have objects with the same names but in different.

There was a problem with interaction with MS SQL Linked Server. It request information via metadata schemes for case-dependent names without quotation marks. For example, when receiving descriptions of columns for Table1, description of columns for TABLE1 returned in MS SQL.

Now IBProvider can work correctly, including with the following structures of Firebird and InterBase:

CREATE TABLE "TableWithMixName2"
("COL" VARCHAR(100),
 "Col" VARCHAR(101),
 "col" VARCHAR(102));

CREATE TABLE "TABLEWITHMIXNAME2"
("COL" VARCHAR(100),
 "Col" VARCHAR(101),
 "col" VARCHAR(102));

CREATE PROCEDURE "SP_EXEC__WithMixName2"
 ("arg" VARHAR(110),
  "arG" VARHAR (111),
  "aRg" VARHAR (112),
  "aRG" VARHAR (113))
RETURNS
 ("Arg" VARCHAR (114),
  "ArG" VARCHAR (115),
  "ARg" VARCHAR (116),
  "ARG" VARCHAR(117)
)
AS
BEGIN
 /*some code*/
END;

Publish date: 2010-09-16. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.