05/11/2007 :: What's important to know when working with UNICODE? -
FIBPlus versions 6.0 upwards do support UNICODE. Earlier FIBPlus versions did not have this feature, that's why it was NOT possible at all to use charset of the UNICODE_FSS connection and no details about the database contents were provided . This article is aimed at explaining how to work with UNICODE correctly.
In this article we will try to give a number of recommendations and examples, which will enable developers to create more effective InterBase and Firebird applications. These technologies of optimization of network traffic can be applied to multi-user environment and systems that address to the server using low-speed channels (i.e. ISDN).
02/21/2007 :: FIBPlus: handling database errors - One of best FIBPlus advantages is its database error handling mechanism. In this article I will consider it in details. The main component used for error handling is called TpFibErrorHandler. It enables developers to handle errors centrally.
12/16/2006 :: Transactions in InterBase/Firebird: how to use them in FIBPlus (part 4) - InterBase and Firebird servers enable developers to use a single transaction while working with multiple databases. Two-phase commit in limbo transactions and other similar features are described in different articles about transactions, so I will not consider this topic in detail.
SNAPSHOT TABLE STABILITY isolation level reserves tables used in such transaction. There additional features enabling you to reserve tables in the transaction or vice versa to allow other transactions modify tables in SNAPSHOT TABLE STABILITY isolation level. In the SQL language it is a reserving operator, in TPB these are constants isc_tpb_lock_read, isc_tpb_lock_write, isc_tpb_exclusive, isc_tpb_shared, isc_tpb_protected. Here are examples on how to use them in practice.
Transactions in multi-user environment in InterBase/Firebird (and other database servers) are often not the trivial topic. Programmers prefer to use only the isolation level READ COMMITTED regardless the task conditions.
All operations with a database (any changes of data, metadata, data selection, etc) are executed in the context of a transaction. All changes done in the context the transaction can be either committed (if there are no exceptions) or rolled back. You cannot commit the transaction if an exception error appears in any transaction operation, you can only roll back all the operations.
01/23/2006 :: How to work with Blobs - A special data type BLOB enables you to store non-structured data in your database, such as images, OLE-objects, sounds, etc.This article is aimed at telling how to work with BLOB-fields.
02/28/2004 :: FIBPlus. Master-detail. Step 1. Getting data from the table and showing it in TDBGrid. - Peculiarities of master-detail mechanism in the course of work with InterBase. Step 1.
02/28/2004 :: FIBPlus. Master-detail. Step 2. Creation of live queries. Use of generators for getting Primary Key values. - Devrace FIBPlus: Peculiarities of master-detail mechanism in the course of work with InterBase. Step 2
02/28/2004 :: FIBPlus. Master-detail. Step 3. AutoCommit Mode. Work in the context of two transactions for avoiding DEADLOCK - Devrace FIBPlus: Peculiarities of master-detail mechanism in the course of work with InterBase. Step 3.
02/28/2004 :: FIBPlus. Master-detail. Step 4. Master-detail link. Use of a special prefix "MAS_" for parameter naming. - Devrace FIBPlus: Peculiarities of master-detail mechanism in the course of work with InterBase. Step 4.
02/28/2004 :: FIBPlus. Master-detail. Step 5. Customizing master-detail mechanism. - Devrace FIBPlus: Peculiarities of master-detail mechanism in the course of work with InterBase. Step 5.
01/30/2004 :: Delphi Informant has published Bill Todd's article about FIBPlus -
Bill Todd comes to the only conclusion
09/06/2003 :: Boolean fields in applications for InterBase and Firebird - The absence of evident support of boolean fields in InterBase always surprised and interested the developers who used this server. And in any case these developers had to emulate the support of boolean fields.
09/06/2003 :: Using of FIBPlus macros - While working with TpFIBDataSet and TpFIBQuery it is also possible to use in the query macroses...
09/06/2003 :: InterBase and Firebird server transactions and their support in FIBPlus - This topic is based on the article written by Michael Zhuravlev (firstname.lastname@example.org).
Frequently Asked Questions (FAQ)
06/27/2007 :: Where and how to use FIBPlusTools?
03/01/2007 :: Why don’t FindFirst and FindNext methods work?
12/16/2006 :: How to create a "persistent" calculated field?
12/16/2006 :: Is there an easy way to clone database connections?
12/16/2006 :: Can I get an example of LockRecord coding?
12/16/2006 :: Does TFIBStringField support Unicode fields?
12/16/2006 :: How to check whether a table exists or not?
02/10/2006 :: Problem with data not being visible between workstations
02/10/2006 :: What does the option PoForceIsNull mean?
02/10/2006 :: How to check whether a table exists or not?
02/09/2006 :: How to install FIBPlus with Rubicon driver?
Release notes for new FIBPlus versions
04/22/2013 :: FIBPlus 7.4.5 Release Notes - What’s new in version 7.4.5: useful enhancements in TpFIBScripter component and 18 bug-fixes.
10/21/2012 :: FIBPlus 7.4 Release Notes - What’s new in version 7.4: RAD Studio XE3 support, a few useful enhancements and 6 bug-fixes.
04/01/2012 :: FIBPlus 7.3 Release Notes - What’s new in version 7.3: a few useful enhancements and 16 bug-fixes.
07/04/2011 :: FIBPlus 7.1 Release Notes - What’s new in version 7.1: new components for NBackUp support for Firebird 2.5, compatibility with new MDT version and 10 bug-fixes.
12/24/2010 :: FIBPlus 7.0.15 Release Notes - What’s new in version 7.0.15: 10 bug fixes.
11/29/2010 :: FIBPlus 7.0 Release Notes - What’s new in version 7.0: 20 enhancements, 13 bug fixes.
11/11/2009 :: FIBPlus 6.9.9 Release Notes - What’s new in version 6.9.9: 6 enhancements, 16 bug fixes.
03/05/2009 :: FIBPlus 6.9.6 Release Notes - What’s new in version 6.9.6: 6 enhancements, 6 bug fixes.
01/27/2009 :: FIBPlus 6.9.5 for Delphi/C++ Builder 2009 Release Notes - What's new in version 6.9.5: supports Delphi and C++ Builder 2009
08/24/2008 :: What's new in version 6.9.5 -
What’s new in version 6.9.5: 3 enhancements, 12 bug fixes. Has in particular improvements in an ErrorMessage repository. Besides the FIBPlus code has been improved for further compatibility with BDS 2009.
10/14/2007 :: FIBPlus 6.8 Release Notes - What's new in version 6.8: 9 enhancements, 8 bug fixes. Has a new TpFIBScripter component and supports CSMonitor.
05/10/2007 :: FIBPlus 6.7 Release Notes - What's new in version 6.7: 7 enhancements, 14 bug fixes. Supports InterBase 2007 and Delphi 2007
05/10/2007 :: All new FIBPlus features, enhancements and bug fixes in versions 4.8-6.7 - That is new in versions 5.0-6.7: 135 enhancements, 161 bug fixes. Supports InterBase 2007 and Delphi 2007
12/06/2006 :: FIBPlus 6.5 Release Notes - What's new in version 6.5: 7 enhancements, 15 bug fixes. Better support of Firebird 2.0
07/24/2006 :: FIBPlus 6.45 Release Notes - What's new in version 6.45: 7 enhancements, 16 bug fixes. Support of C++ Builder 2006.
05/01/2006 :: FIBPlus 6.4.1 Release Notes - What's new in FIBPlus 6.4.1, bug-fixes, etc
02/15/2006 :: Release Notes for version 6.4 - Read about better library stability, 4 enhancements, 11 bug fixes and better compatibility with Delphi 2006.
12/01/2005 :: FIBPlus 6.3 Release Notes - Read about better library stability, 15 enhancements, 20 bug fixes and better compatibility with C++ Builder, Kylix, Firebird 2 and InterBase 7.5.
05/25/2005 :: FIBPlus 6.25 Release Notes - Read about new methods for better Firebird 2 support and many bug fixes
04/19/2005 :: FIBPlus 6.2 Release Notes - This version better supports Unicode and is compatible with Firebird 2 and Delphi 2005
01/11/2005 :: FIBPlus 6.1 Release Notes - This version includes bug-fixes of FIBPlus 6.0
11/16/2004 :: Hot fixes for FIBPlus 6.0 - Use these hot fixes for FIBPlus 6.0 if you would not like to wait for FIBPlus 6.0 Service Pack
11/10/2004 :: What's new in version 6.0? - New features, bug-fixes
02/17/2004 :: FIBPlus 5.2 Release Notes - What's new in FIBPlus 5.2
11/10/2003 :: FIBPlus 5.1 Release Notes - New features, changes and bug-fixes
10/15/2003 :: FIBPlus 5.0.8 Release Notes - What's new in FIBPlus 5.0.8: new features and enhancements, bug fixes.
09/30/2003 :: FIBPlus 5.0 release notes - What's new in FIBPlus 5.0? Features, enhancements and fixed bugs.
04/24/2007 :: LICENSE STATEMENT Devrace FIBPlus -
IMPORTANT - READ CAREFULLY
NOTICE: THIS DEVRACE SOFTWARE PRODUCT (TOGETHER WITH ITS ACCOMPANYING DOCUMENTATION, THE "PRODUCT") IS THE PROPERTY OF DEVRACE COMPANY ("DEVRACE"). THE PRODUCT IS MADE AVAILABLE TO YOU, THE ORIGINAL PURCHASER, SUBJECT TO THE FOLLOWING LICENSE AGREEMENT ("LICENSE AGREEMENT" OR “AGREEMENT”). PLEASE READ THIS LICENSE CAREFULLY BEFORE INSTALLING OR USING THE PRODUCT. A COPY OF THIS LICENSE IS AVAILABLE FOR YOUR FUTURE REFERENCE IN THE "LICENSE.RTF" FILE PROVIDED WITH THE PRODUCT.
05/02/2006 :: FIBPlus trainings in Germany and Italy
09/06/2003 :: FIBPlus as an alternative for access to InterBase and Firebird - What is FIBPlus and what are its advantages?
12/01/2001 :: FIBPlus on InterBase 6.5 Roadshow in Germany - FIBPlus has been presented in Germany on InterBase 6.5 roadshow jointly with Borland and Better-Office.
05/01/2001 :: Comparative productivity of access means to InterBase and Firebird. - Devrace FIBPlus team has tested different direct InterBase and Firebird connectivities for Delphi and C++ Builder. Would you like to know what advantages and disadvantages of each component set are?