INTERBASE EXPRESS UPDATE KIT FOR InterBase 6, 7 & 2007 ------------------------------ Welcome to the InterBase Express Update Kit for BDS 2006 and InterBase 6, 7 & 2007! Please report all issues to Quality Central (qc.borland.com). IBX bugs/suggestions go in the add-on\InterBase components area. Whenever possible please include a test case against the employee sample database that comes with InterBase. TABLE OF CONTENTS ----------------- 1. What's New in the IBX Update Kit 2. Installing the IBX Update Kit 3. Uninstalling the IBX Update Kit 4. Fixes since BDS 2006 original release 1. WHAT'S NEW IN THE IBX UPDATE KIT ------------------------------------- For detailed information on new features of this release, refer to the online help. In the help contents, choose "What's New in Delphi". IBXpress100.bpl breaks the earlier interface. Any package that depends on ibxpress.dcp will require recompiling after installing this update. You will get an error message that a function is missing and do you wish to load this package later. Answer Yes to this (you will get it twice) and then rebuild the package. Answering no placed the package into a special location in the registry and you can never have it load on startup again without manually modifying the registry. ReportBuilder has a package named rbIBEXx.dpk which falls in this category. Also the Bold packages will require a recomile (you can find a copy of the package itself in CodeCentral also). If you have previously installed IBClientDataSet (see below) it will also require a recompile. 2. INSTALLING THE IBX UPDATE KIT ------------------------------------- Double-click on the IBX Update Kit setup file (IBX_BDS2006_11.EXE) to automatically launch the IBX 10.11 setup program. Follow the setup steps from there. 3. UNINSTALLING THE IBX UPDATE KIT ------------------------------------ The installer was switched to Wise and the option to store the backup of the previous files is given. Follow the normal uninstall option in the Add/Remove programs on the control panel. 4. Fixes/Changes since BDS 2006 release ------------------------------------ 1. IBDatabase.pas - Added support for the IBDatabase param 'instance_name'. User instance_name when you need to set a port to something other than the normal 3050. 2. IBDatabase.pas - IBDatabase added OnlineDump. This implements the new online dump feature of IB 2007. It takes two arrays as parameters. The first array is an array of file names. The second is an array of sizes. They should match up with each other. IOW, file array element one matches size element one. Only the final file is allowed to not have a size associated with it. The final two parameters are Full and Overwrite. Passing true for Full does a full dump, false incremental since the last dump. Passing true for Overwite will overwrite existing files, false will raise and error if the files exist. 3. IBQuery, IBTable, IBDataset, IBStoredProc - Added PSSetCommandText where WideStrings are passed. 4. IBScript - Added support for commit retaining and rollback retaining. 5. IBScript - Added support for the IN 2007 batch script API. Like ISQL calling 'Batch start' starts a batch update and calling 'Batch Execute' will execute the batch statements. Only insert, update and delete statements are supported by this API. 6. Services - Added support for the instance_name parameter. 7. IBConfigService - Added two properties for database and transaction. For the features added since 7.5 some of are straight SQL DDL. In the past IBConfigService would just create an INDatabase and INTransaction as needed. It still will, but if you supply a databsae and transaction it will use that first. This is needed for some features like the new journaling that requires exclusive access to the database. 8. TIBJournalInformation - New class for displaying and setting Journal settings on a database. Mainly this is access from the IBConfigService component. properties (see IB documentation for full information on these properties) HasJournal - Boolean, true if journaling is turned on. HasArchive - Boolean, true if archiving has been turned on CheckPointInterval - Integer CheckPointLength - Integer PageCache - integer PageLength - Integer PageSize - Integer TimestampName - Boolean Directory - String 9. IBConfigService - New property JournalInformation. Read and write to this to manipulate journaling information on a database. Call GetJournalInformation to retrieve the Journaling information for a database. a) CreateJournal - create a journal based on the JournalInformation. b) AlterJournal - alters a pre existing journal system. Not all properties can be altered. See the IB documentation for limitations. c) DropJournal - drops a journal system. d) CreateJournalArchive - creates an archive. Takes an optional directory parameter. e) DropJournalArchive - Drops an archive. f) GetJournalInformation - retrieves journaling information for this database and stores it in the JournalInformation property. g) JournalInformation (property) - Access to the underlying IBJournalInformation field. 10. IBSecurityService - Fixed bug where modifying a users was actually trying to create a user. 11. IBVersionInfo - fixed a bug in the IsMinimumVersion function. 12. IBConfigService - Design time component editor now has a GetJournalInformation menu option. This is only registered if you have IB 2007 client installed.