Components, help files, documentation

06/01/2013 FIBPlus 7.5 for Delphi and C++ Builder Installation FIBPlus 7.5 package for Delphi 5-7, C++ Builder 5-6, BDS 2005-2007, RAD Studio 2009-2010, RAD Studio XE-XE4
06/29/2007 FIBPlus 6.7 for Kylix 3 Installation package with sources and FIBPlusTools
03/15/2007 FIBPlus Developer's Guide Part 2 (NEW) FIBPlus Developer's Guide in printable format (PDF). Part 2. (NEW)
12/06/2006 Help for C++ Builder 2006 FIBPlus Help file for C++ Builder 2006
07/23/2006 Help for Delphi 2005 FIBPlus help for Delphi 2005
07/23/2006 Help for Delphi 2006 FIBPlus help for Delphi 2006
06/20/2006 FIBPlus Developer's Guide Part 1 (NEW) FIBPlus Developer's Guide in printable format (PDF). Part 1. (NEW)
02/20/2004 Help for Delphi 6 FIBPlus Help file for Delphi 6
02/20/2004 Help for Delphi 5 FIBPlus Help file for Delphi 5
02/20/2004 Help for C++ Builder 6 FIBPlus Help file for C++ Builder 6
02/20/2004 Help for C++ Builder 5 FIBPlus Help file for C++ Builder 5


Examples

06/01/2013 FIBPlus examples for FireMonkey FIBPlus examples for FireMonkey in RAD Studio XE4
02/22/2010 New full package of all examples for Delphi

Recommended! The newest package of FIBPlus examples (for Delphi) demonstrates 36 main FIBPlus features (tested on FIBPlus version 6.9.9). You will learn how to:

  • work with automatic reconnection to the database (OfflineWork). NEW
  • use different refreshes, including new RefreshFromQuery (RefreshDataSet). NEW 
  • work with TpFIBDataSet, to connect to the database and set SQL's in the editor.
  • use TpFIBDataSet options
  • set TpFIBDataSet at run-time to make it Insert, Delete and Modify records
  • use the master-detail mechanism
  • use local sorting and local filtering
  • work with FIBPlus field repository, FIBPlus DataSet Repository, FIBPlus Error Message Repository
  • work with events
  • execute a background query in another thread
  • create SQLMonitor to monitor FIBPlus queries to a database
  • use a new statistics logging service
  • work with CacheSchemaOptions options
  • handle lost connections
  • use blob filters
  • work with Unicode
  • work with IB/FB array fields
  • use stored procedures
  • use the TpFIBDataSet mode with the limited buffer size
  • send connection parameters in DLL
  • work with array fields, process fields for displaying and then pack for modification
  • use a new FB2.0 feature insert into returning
  • generate GUID at the server
  • use broadcast notification mechanism
  • use FIBPlus services, etc...
By Nicolay Voynov
02/26/2004 Alter database example This example demonstrates how to add a new secondary file to the existing database
02/26/2004 Backup/Restore example (Delphi, C++ Builder) This example demonstrates how to backup and restore databases
02/26/2004 CharacterSet example (Delphi, C++ Builder) This example allows you to view the following InterBase system tables: RDB$CHARACTER_SETS and RDB$COLLATIONS.
02/26/2004 CreateDatabase example (Delphi, C++ Builder) Run and set the full path to a new database. The directory you set should already exist.
02/26/2004 DBFilesPages example This example displays the information about secondary database files and pages.
02/26/2004 DBGeneratorsExceptions example (Delphi, C++ Builder) This example displays the database generators and exceptions.
02/26/2004 ErrorHandler example (Delphi, C++ Builder) This example demonstrates error handling.
02/26/2004 Filtering example (Delphi, C++ Builder) This example demonstrates how to use local dataset filtering.
02/26/2004 Relations example (Delphi, C++ Builder) This example displays the following InterBase system tables:RDB$RELATIONS and RDB$RELATION_FIELDS.
02/26/2004 SavePoint example (Delphi, C++ Builder) This example demonstrates how to use "nested transactions"...
02/26/2004 Shutdown/Restart example (Delphi, C++ Builder) This example enables you to shut down and restart a database.
02/26/2004 StoredProcedures system tables (Delphi, C++ Builder) This example enables you to view the following InterBase system tables: RDB$PROCEDURES and RDB$PROCEDURE_PARAMETERS.
02/26/2004 Triggers example (Delphi, C++ Builder) This example enables you to view the following InterBase system tables: RDB$TRIGGER_MESSAGES and RDB$TRIGGERS.
02/26/2004 DBUDF system tables example (Delphi, C++ Builder) This example enables you to view the following InterBase system tables: RDB$FUNCTIONS and RDB$FUNCTION_ARGUMENTS.
02/26/2004 UpdateObject example (Delphi, C++ Builder) This example demonstrates how to use the TpFIBUpdateObject component.
10/08/2003 BatchToQuery example This example demonstrates how to use TpFIBQuery.BatchToQuery method to copy data from one database to another. Necessary databases (*.gbk) are included.
11/26/2002 IntraWeb example (Delphi) IntraWeb example (Delphi). It shows how to use FIBPlus together with IntraWeb components and how to use FIBPlus advantages (local sorting) for web-development (requires FIBPlus_Example.gdb).
01/14/2002 Demo Pack by Dmitry Kovalenko (Delphi)

Demo Pack by Dmitry Kovalenko (Delphi). It includes:

  • Simple query sample
  • Sample with graphic blob-fields (Fish demo)
  • Handling event alerts sample
  • Local filtering sample
  • Local sorting sample
  • Local searching sample
  • Local and server-side searching sample
  • Master-detail example
  • Loading a form from DLL
  • Using FIBPlus Cache***() methods
  • FIBPlus and MIDAS example
  • FIBPlus glyphes for Delphi and C++ Builder IDE

The necessary database is included in archives.

12/12/2001 Databases for FIBPlus examples (required) InterBase databases required for all FIBPlus samples, except of "Demo pack" by Dmitry Kovalenko
12/12/2001 AliasManager example (Delphi, C++ Builder) AliasManager example (Delphi, C++ Builder). It contains sources of AliasManager, which helps you to use such a special FIBPlus feature as Aliases in TpFIBDatabase (the Alias property).
12/12/2001 Array-fields demo (Delphi, C++ Builder) Array-fields demo (Delphi, C++ Builder). It demostrates two ways how to use array-fields with the help of FIBPlus. The first way is to get and set array-field values using special methods. The second way shows how to use array-fields in any standard visual db-ware components.
12/12/2001 Local sorting example (Delphi, C++ Builder) Local sorting example (Delphi, C++ Builder). it shows how to use DoSort method of TpFIBDataSet for local sorting data that is without re-open of a query.
Events example (Delphi, C++ Builder) This example demonstrates how to post and handle InterBase events.


Third-party tools

12/07/2006 A component for work with .JPG files in FIBPlus

A component for work with .JPG file in FIBPlus. It's a modified DBImage and it works well with .JPG files.

Note: this component has been tested only for Delphi 6, so if you are using other Delphi versions, maybe you'll need to modify the component.

02/17/2005 FIBPlus and Report Builder (DADE) integration ReportBuilder Pro (DADE) integration with FIBPlus by Alan G. Livingstone. Delphi 7
10/11/2004 Atstariff FIBPlus Script

Commercial SQL-script components with good technical support by its author - Nikolay Trifonov. The component implements:

  • all DDL-statements: DECLARE, ALTER, CREATE, etc.
  • database connection/disconnection commands.
  • transaction management commands: START TRANSACTION, COMMIT, etc.
  • support of Firebird 1.0/1.5/2.0 and InterBase 7.x SQL.
  • the IBExpert command: DESCRIBE and SET BLOBFILE
  • This script component also does not require SET TERM command to separate ALTER TRIGGER and ALTER PROCEDURE statements.
  • Includes SQL Script and SQL Extract modules.

Recommended by Devrace.

05/18/2004 gb_DataSets Components 1.04

by Spirin Sergey (e-mail: paritet@spa.msu.ru)

gb_DataSets Components is a set of components providing an opportunity of normal navigation on large data sources - tables and queries. The set consists of two components: TgbDataSet and TgbTable. The first one provides caching, navigation, editing on a random data set which has returned SQL-query, the second provides similar functionality on a separate table. Unlike standard IBX- and FIBPlus-DataSets, gb_DataSets never download the all data from the InterBase server. So, the basic distinction between such components as IBTable, IBDataSet, IBQuery, pFIBDataSet, consists in cache architecture and
server request technique.

The current version supports FIBPlus 5.3. If you use previous FIBPlus version, you can try gb_DataSets 1.03

05/05/2004 pFIBExtract Updated for Delphi 2006. The pFIBExtract component ported from IBX by Iliya Iliev. This component enables you to extract database metadata to SQL script.
05/05/2004 pFIBScript Updated for Delphi 2006. Iliya Iliev has ported pFIBScript component from IBX. This component enables you to execute SQL scripts in your applications
11/26/2003 ASTA Server based on FIBPlus ASTA Server based on FIBPlus by the ASTA Technology Group (http:// www.astatech.com).
02/14/2003 TDBVirtualStringTree

TDBVirtualStringTree is a descendant of VirtualStringTree. VirtualStringTree is at www.lischke-online.de. This is a tree, that loads data on opening a branch. It
is editable and contains filtering and search methods, supports drag and drop and you can use it in the checkbox mode.

Includes components for using TDBVirtualStringTree with FIBPlus and demo project.

02/10/2003 User Control Package

User Control Package is a freeware package of components compatible with FIBPlus that easily allows to control access to the programs developed in Delphi 6 and 7. It supports main standards of data access and Database servers compatible with Delphi. The menu items control is made in an automatic way. The menu items are extracted from the TMenu attributed to the main Form. Also it is possible to control access to the buttons and other objects supporting Actions. The access can be defined by User and Profiles of User. It also allows to log events in the program.

10/18/2001 InterBase Visual SQL InterBase Visual SQL by Ecological Software Solutions.
10/18/2001 Components for FIBPlus and FastReport integration

These archives also include some comments from Vitaly Barmin about installation and use in Delphi 3.

09/07/2001 SQL Editor Design-time SQL Editor from Andrew Semack (e-mail: sammy@profix.poltava.ua)
07/16/2001 Visual IBQueryBuilder Visual IBQueryBuilder written by Dennis Ortiz Vives (e-mail: d2ortiz@prtc.net)
07/16/2001 InterBase EventAlerter New InterBase EventAlerter for FIBPlus by Vadim Yegorov. (e-mail: zg@matrica.apollo.lv)
07/16/2001 Components for dbPager based on FIBPlus Components for dbPager based on FIBPlus by Eugene Bayanov (e-mail: bayanov@alt.ru; home page: http://bayanov.newmail.ru/)
07/16/2001 Pictures for FIBPlus components based on IBX Pictures for FIBPlus components based on IBX by Dmitriy Kovalenko. Updated for FIBPlus 4.1 (e-mail: dmitriy@morion.kiev.ua)


Tools based on FIBPlus

11/18/2003 BT SQLMonitor

BT SQLMonitor is a free tool enabling to monitor connections to databases, SQL-queries and transactions of applications written on IBX and FIBPlus.

Features:

  • Monitoring of connection to/disconnection from databases.
  • Monitoring of transaction start/end.
  • Monitoring of use of Services API.
  • Monitoring of preparation and execution of queries showing query text and parameter values.
  • Monitoring of fetching records.
  • Ability to activate/deactivate monitoring for a certain time.
  • Ability to set operations that should be monitored.
  • Ability to trace work of IBX and FIBPlus applications simultaneously.
  • Automatic creation of lists of traced operations with ability to switch quickly to the necessary operation.
  • Saving the log into the file.
01/14/2002 MiTeC InterBase Query 2.6

MiTeC Interbase Query is a freeware InterBase 6.0 managing tool written by MichaL MutL. If you enjoyed old WISQL you will like this tool too :). It is a small and nice query and script editor, which is compatible with Interbase 6.0 and Firebird. Features:

  • SQL Editor (result is in text format not in grid).
  • Object Explorer
  • Data Explorer
  • User Management
  • Export Data to XLS, DBF, CSV, RAW
  • Database Creation
  • Database Validation
  • Database Statistics
  • Server Log View
01/14/2002 MiTeC Interbase Performance Monitor 2.0.6

This freeware tool is written by MichaL MutL. It scans and shows some parameters of Interbase state such as:

  • Memory and CPU usage
  • Reads from memory buffer cache
  • Writes to memory buffer cache
  • Reads from database
  • Writes to database
11/18/2001 SQL Monitor Using SQL Monitor you can view and log any operations with databases in applications written with FIBPlus. SQL Monitor allows to view separate applications and set a filter on needed sql-operations: connection/disconnection, control of transactions, preparation and execution of queries.
10/18/2001 SQL Monitor by Boris Ermoshin

SQL Monitor is a tool for tracking operations between server and client applications. This program is similar to standard Delphi SQL Monitor. Written by Boris Ermoshin (historymail@public.mtu.ru). Features:

  • Transactions control
  • Database connections and disconnections
  • Selecting actions
07/16/2001 EMS IBManager (former QuickDesk) InterBase/Firebird Administration Tool
07/16/2001 FIBPlus Alias Manager Alias Manager is a tool for editing FIBPlus database aliases. Using Alias Manager you get a very convenient access to information about aliases in the system registry.
07/16/2001 IBAlterView

IBAlterView - is a unique tool, it allows you to emulate the 'ALTER VIEW' command which at present exists neither in Interbase, nor in FireBird.

Before the existence of IBAlterView for changing the description of some certain view you manually had to cut off all the objects even to some extent dependant on this view. Now IBAlterView will do this itself! Of course we cannot guarantee that you will be 100% successful but in most cases our tool will be your best and indispensable helper!

For being on the safe side, please, make copies of your database before using IBAlterView. :-)



Integration of FIBPlus and third-party tools and components

10/01/2012 FIBPlus and Rave Report integration Components for FIBPlus and Rave Report integration
12/17/2006 FIBPlus and Context Database Designer & Database Extensions v.2.11 integration Components for FIBPlus and Context Database Designer & Database Extensions v.2.11 integration + a demo example.
08/01/2006 FIBPlus and TMS Scripter Studio integration Components for FIBPlus and TMS Scripter Studio integration, integrated IDE for script debugging and script examples
07/25/2006 FIBPlus and TMSAdvDBGrid integration Components for FIBPlus and TMSAdvDBGrid integration
07/24/2006 FIBPlus and FastReport 2.56 integration Components and example of FIBPlus and FastReport 2.56 integration (supports Delphi 2006)
07/10/2006 FIBPlus and DataAbstract integration Components for FIBPlus and DataAbstract (Remobjects) integration
06/20/2006 FIBPlus and EhLib integration Components and example of FIBPlus and EhLib integration
02/20/2006 FIBPlus and FastReport 4.0 integration Components for FIBPlus and FastReport 4.0
01/27/2006 FIBPlus and Fast Query Builder integration Components and demo example of FIBPlus and Fast Query Builder 1.03 integration
01/18/2006 FIBPlus and Rubicon integration Components and example of FIBPlus and Rubicon integration. How to install Rubicon driver with FIBPlus?
01/18/2006 FIBPlus and FastReport 2.0 integration Components and demo example of FIBPlus and FastReport integration.
12/19/2005 FIBPlus and Report Builder integration Components and example of FIBPlus and Report Builder integration
12/19/2005 FIBPlus and Jazmine (JCW) integration Components and example of FIBPlus and Jazmine (JCW) integration


Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



"If every software supplier had a product, and a support staff as good as yours, life would be much easier for developers." >>

John Hart
FOR CUSTOMERS
Download full versions and updates in your Personal Area