Today, on January 18, 2010, IBProvider celebrates its 10th anniversary.
The grand banquet is preceded by the release of the latest IBProvider version with enhanced support of DDL and updatable rowsets.

IBProvider turns 10 years today

• We thank all who have been with us all these years.
• We thank FibPlus, ZStyle Group, Gemini InterBase/Firebird ODBC Driver, Easysoft ODBC-InterBase Driver, IBObjects. Owing to you, we have what to compare IBProvider to; together we make a big deal of promoting Firebird and Intrebase among masses.
• We thank Firebird developers. Owing to you, people have a good free database server.
• We thank our clients. Owing to you, IBProvider has been developed and will be developed.

Changes in IBProvider v.3.0.0.8416

DDL query "COMMENT ON" in Firebird 2.1

COMMENT ON – is a DDL query, which allows setting up description for database objects. It was first introduced in Firebird 2.1 .

When running COMMENT ON DDL query, IBProvider auto_commit_ddl and auto_commit_ddl_level properties are taken into account.

Examples of COMMENT ON for Firebird 2.1

COMMENT ON DATABASE IS 'NASA Database';

COMMENT ON for: DOMAIN, TABLE, VIEW, PROCEDURE, TRIGGER, EXTERNAL FUNCTION, FILTER, EXCEPTION, GENERATOR, SEQUENCE, INDEX, ROLE, CHARACTER SET, COLLATION

COMMENT ON DOMAIN CUSTNO IS 'DOMAIN FOR CUSTOMER NUMBER';

COMMENT ON COLUMN EMPLOYEE.EMP_NO IS 'Employee number'

COMMENT ON PARAMETER add_emp_proj.EMP_NO IS NULL;

Updatable rowsets code revision in IBProvider v.2.6.16.2972

• We revised and enhanced updatable rowsets code.
• We improved testing system for Updatable rowsets.

We recommend upgrading to all clients who use updatable rowsets in IBProvider v2.