Download FIBPlus

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

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

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.

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.

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.

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

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

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.

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.

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.
  

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

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

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

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. :-)