What's new in version 5.0?

Features and enhancements:

  1. The editor of FIBPlus DataSet Repository has been changed.
  2. Now TpFIBDatabase has the UseRepositories property. Setting it equal False you can deactivate by force use of any kind of repository support in the whole application.
  3. The useRepositaries property has been renamed to useRepositories.
  4. The TFIBXSQLDA.AssignValues method has been added.
  5. New fields:
    UPDATE_TABLE_NAME,
    UPDATE_ONLY_MODIFIED_FIELDS and
    CONDITIONS

    have been added in FIBPlus DataSet Repository.
  6. Dataset timers are created now not by default, but only when they are necessary.
  7. The property ValidateAfterLoad: boolean has been added to TpFIBDatabase.CacheSchemaOptions. If you set it equal False, FIBPlus will not try to check the saved metadata scheme after loading.
  8. TpFIBQuery has now the public read-write PlanClause property.
  9. The button SaveSQL does not check the SQL syntax in SQLEditor if this check is not activated.
  10. The SqlTxtRtns module has been entirely rewritten.
  11. The UpdateTransaction behaviour has been changed. Now it starts only at the moment of execution of a modifying query. The query preparation is executed in open transactions.
  12. TpFIBDatabase.Gen_Id is called now in the first available open transaction and does not create its own one.
  13. Work with new InterBase keywords has been improved.
  14. The AsIn64 property has been added to TFIBBCDField (for all Delphi versions starting from Delphi 4).
  15. A property responsible for the generator step has been added to AutoUpdateOptions of TpFIBDataSet.
  16. Some events have been renamed:

    * TpFIBDatabase.Onlogin is changed to BeforeConnect,
    * TpFIBDatabase.OnConnect is changed toAfterConnect.
  17. Support of server exceptions during work with Foreign Keys, Check Constraints and Unique Constraints has been added to TpFibErrorHandler.To activate this feature you need to activate the corresponding option in the Options property in TpFIBErrorHandler and create the following table in the database:

    CREATE TABLE FIB$ERROR_MESSAGES (
    CONSTRAINT_NAME VARCHAR(67) NOT NULL,
    MESSAGE_STRING VARCHAR(100),
    FIB$VERSION INTEGER,
    CONSTR_TYPE VARCHAR(11) DEFAULT 'UNIQUE' NOT
    NULL
    );

    Creation of and work with this table is implemented in the TpFIBDataBase component editor now.
  18. Two new properties have been added to AutoUpdateOptions:

    a) ParamsToFieldsLinks: TStrings Enables to set accordance between dataset fields and parameters in the form FieldName=ParamName. Then this accordance is used in the internal handler before calling OnNewRecord. The parameter value is automatically set to the defined field;

    b) AutoParamsToFields: boolean If you set this property equal True, TpFIBDataSet tries to set the ParamsToFieldsLinks property itself analyzing the SelectSQL text. (run-time only)
  19. The DefaultUpdateTransaction property has been added to TpFIBDatabase. Being added to the form after setting DefaultUpdateTransaction, all the TpFIBDataSet sets will use this property value in order to set the UpdateTransaction property.
  20. Now TpFIBTransaction has methods:

    * SetSavePoint(const Name: string) and
    * RollBackToSavePoint(const Name: string)
    (only for FB 1.5)
  21. Now TpFIBDatabase has the property ServerActiveTransactions: TStringList, which returns a list of active transaction identifiers of the current database at the server. This list returns an ID list of transactions active at the moment (only for FB 1.5)
  22. Minor changes in TFIBSQLMonitor, enabling it to monitor new operations with SavePoint.

Fixed bugs:

  1. On opening SQL Generator a table list from the database was shown while in ListBox there was written "Closed". Fixed.
  2. Names of the changed queries were not highlighted in the SQL editor. Fixed.
  3. The choice variants of the key field (KeyFields) BIGINT were not added to the dataset in AutoUpdateOptions. Fixed.
  4. A number of bugs in FIBPlus DataSet Repository have been fixed.
  5. The design-time editor of the Options property of TpFibDataSet did not work, if there were chosen several components. Fixed.
  6. Stack overflow on changing OrderClause, if the Conditions property was used. Fixed.
  7. Incorrect work of BatchOutputRawFile, if there were VARCHAR fields in queries. Fixed.
  8. Some changes in the FullRefresh method (the curent position of the cursor did not remain).
  9. UpdateTransaction works correctly now, if the database has the default UpdateTransaction.
  10. Work with macros has been improved. In particular, the error of hadnling some SQL with macros has been fixed.
  11. The bug with blob-fields in InternalPostRecord when CachedUpdates mode is True. Fixed.
  12. The default fields did not remain after FullRefresh. Fixed.
  13. The SqlTxtRtns unit has been completely rewritten.
  14. The insertion into an empty dataset on using a separate modifying transaction. The changes were not written into the BLOB-field. Fixed.
  15. In some cases Boolean fields were emulated only after Delphi restart. Fixed.
  16. The Field designer did not start in case when an incorrect SelectSQL was written in the dataset. Fixed.
  17. Errors of work with RDB$DB_KEY have been fixed.
  18. Incorrect transaction check on ApplyUpdates. Fixed.
  19. An error in FIBDatabase.QueryValue, if the returned field is BLOB. Fixed.
  20. The problem with non-text BLOB fields has been fixed.
  21. Some bugs in macro functions have been fixed.
  22. Some bugs with DDL queries have been fixed.
  23. Access Violation in SQL Editor has been fixed.
  24. Some bugs in the editor of the Options property of TpFIBDataSet have been fixed.
  25. Errors of use of RDB$DB_KEY in TpFIBDataSet. Fixed.
  26. Errors occured on checking an active transaction in ApplyUpdates. Fixed.
  27. Errors in FIBDatabase.QueryValue, if the returned field is BLOB. Fixed.
  28. Changes of a BLOB-field were not saved after the record insertion into an empty dataset in the context of a separate modifying transaction. Fixed.
  29. An error in the LocateNext method. Fixed.
  30. An error of Boolean-field emulation in design-time. Fixed.
  31. An error when Field Editor did not start if an incorrect SelectSQL was set in TpFIBDataSet. Fixed.
  32. An error of work with queries "Select for update". Fixed.
  33. An error of handling Cancel after the exception during execution of the INSERT-query. Fixed.

Preview text: What's new in FIBPlus 5.0? Features, enhancements and fixed bugs.
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



We are a small software company with thousands of customers delivering comany wide systems including accounting, logistics, e-commerce, POS, sales etc etc. Several years ago, when we were still a very small company, we used Delphi 3 and Paradox combined with BDE. As our system (and customer base) grew I decided to switch to Delphi 5 and Interbase. Being a huge improvement over Delphi 3 and Paradox, I encountered numerous problems with IBX: memory leaks, performance issues and other problems. Borland was not to be bothered: IBX was provided "as is" and no support was avaliable. 
Not being very eager to use third party components with Delphi at first, I decided to give FIBPlus a try. At once all problems where gone: no more memory leaks and  performance was very consistent. 
But the real advantage of switching to FIBPlus came with the upgrade to D2005: after upgrading there were some problems with the new FIBPlus version. After emailing the problem I received an update within an hour! And this was at 11 pm! A few other (smaller) errors where handled in the same way. 
Our motto is: software is as good as its support. And support of Devrace is just great!
Just a little indication of our FIBPlus use: all our software runs 100% on FIBPlus. Our customers have a total of aprox. 4.800 Firebird databases in production, with a combined size of over 130TB and over 80 million transactions a day. Every
day. And FIBPlus has not failed a single transaction. Not once. There is, however, one (minor) drawback in using FIBPlus: while debugging an application which uses and invalid SQL instruction, de Delphi Debugger returns to the FIBPlus code instead of to our calling code (where the actual error comes from), thereby complicating de debug proces a little. But that is a very small price to pay for a otherwise brilliant third party solution! >>

Bas Jordans JorSoft Ltd
FOR CUSTOMERS
Download full versions and updates in your Personal Area