FIBPlus technology

Home :: FIBPlus :: Articles :: FIBPlus technology

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 5. Customizing master-detail mechanism. - Devrace FIBPlus: Peculiarities of master-detail mechanism in the course of work with InterBase. Step 5.

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 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 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

12/11/2006 :: Transactions in InterBase/Firebird: how to use them in FIBPlus (part 2) -

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.

12/12/2006 :: Transactions in InterBase/Firebird: how to use them in FIBPlus (part 3) -

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.

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.

12/11/2006 :: Transactions in InterBase/Firebird: how to use them in FIBPlus (part 1) -

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.

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.

01/30/2004 :: Delphi Informant has published Bill Todd's article about FIBPlus -

Bill Todd comes to the only conclusion

03/22/2007 :: FIBPlus Developer's Guide for FIBPlus (NEW) - FIBPlus Developer's Guide in printable format (PDF). Part 1, Part 2

03/16/2007 :: Devrace FIBPlus: Optimization of network traffic in Delphi and C++ Builder applications -

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.

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.

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 (mikus@mail.ru).