IBDAC

Demo Projects

IBDAC includes a number of demo projects that show off the main IBDAC functionality and development patterns.

The IBDAC demo projects consist of one large project called IbDacDemo with demos for all the main IBDAC components, use cases, and data access technologies, and a number of smaller projects on how to use IBDAC in different IDEs and how to integrate IBDAC with third-party components.

Most demo projects are built for Delphi and Borland Developer Studio. There are only two IBDAC demos for C++Builder. However, the C++Builder distribution includes source code for all other demo projects as well.

Where are the IBDAC demo projects located?

In most cases all the IBDAC demo projects are located in "%IbDac%\Demos\".

In Delphi 2007 under Windows Vista all the IBDAC demo projects are located in "My Documents\Devart\IbDac for Delphi 2007\Demos", for example "C:\Documents and Settings\All Users\Documents\Devart\IbDac for Delphi 2007\Demos\".

The structure of the demo project directory depends on the IDE version you are using.

For most new IDEs with the structure will be as follows.

Demos

|—IbDacDemo [The main IBDAC demo project]

|—ThirdParty

|  |— [A collection of demo projects on integration with third-party components]

|—Miscellaneous

   |— [Some other demo projects on design technologies]

 

IbDacDemo is the main demo project that shows off all the IBDAC functionality. The other directories contain a number of supplementary demo projects that describe special use cases. A list of all the samples in the IBDAC demo project and a description for the supplementary projects is provided in the following section.

Note: This documentation describes ALL the IBDAC demo projects. The actual demo projects you will have installed on your computer depends on your IBDAC version, IBDAC edition, and the IDE version you are using. The integration demos may require installation of third-party components to compile and work properly.

Instructions for using the IBDAC demo projects

To explore an IBDAC demo project,

  1. Launch your IDE.
  2. In your IDE, choose File|Open Project from the menu bar.
  3. Find the directory you've installed IBDAC to and open the Demos folder.
  4. Browse through the demo project folders located here and open the project file of the demo you would like to use.
  5. Compile and launch the demo. If it exists, consult the ReadMe.txt file for more details.

The executed version of the demo will contain a sample application written with IBDAC or a navigable list of samples and sample descriptions. To use each sample properly, you will need to connect to a working InterBase/Firebird server.

The included sample applications are fully functional. To use the demos, you have to first set up a connection to InterBase. You can do so by clicking on the "Connect" button.

Many demos may also use some database objects. If so, they will have two object manipulation buttons, "Create" and "Drop". If your demo requires additional objects, click "Create" to create the necessary database objects. When you are done with a demo, click "Drop" to remove all the objects used for the demo from your InterBase database.

Note: The IBDAC demo directory includes two sample SQL scripts for creating and dropping all the test database objects used in the IBDAC demos. You can modify and execute this script manually, if you would like. This will not change the behavior of the demos.

You can find a complete walkthrough for the main IBDAC demo project in the Getting Started topic. Other IBDAC demo projects include a ReadMe.txt file with individual building and launching instructions.

Demo project descriptions

IbDacDemo

IbDacDemo is one large project which includes three collections of demos.

Working with components

A collection of samples that show how to work with the basic IBDAC components.

General demos

A collection of samples that show off the IBDAC technology and demonstrate some ways to work with data.

InterBase-specific demos

A collection of samples that demonstrate how to incorporate InterBase/Firebird features in database applications.

IbDacDemo can be opened from %IbDac%\Demos\IbDacDemo\ibdacdemo.dpr (.bdsproj). The following table describes all the demos contained in this project.

Working with Components

Name Description
Alerter Uses the TIBCAlerter component to send messages between connections using InterBase events.
ConnectDialog Demonstrates how to customize the IBDAC connect dialog. Changes the standard IBDAC connect dialog to two custom connect dialogs. The first customized sample dialog is inherited from the TForm class, and the second one is inherited from the default IBDAC connect dialog class.
CRDBGrid Demonstrates how to work with the TCRDBGrid component. Shows off the main TCRDBGrid features, like filtering, searching, stretching, using compound headers, and more.
Query Demonstrates working with TIBCQuery, which is one of the most useful IBDAC components. Includes many TIBCQuery usage scenarios. Demonstrates how to execute queries, how to edit data and export it to XML files.

Note: This is a very good introductory demo. We recommend starting here when first becoming familiar with IBDAC.

Sql Uses TIBCSQL to execute SQL statements. Demonstrates how to prepare the statement and how to work with parameters in SQL.
StoredProc Uses TIBCStoredProc to access an editable recordset retrieved by an InterBase stored procedure in the client application.
Table Demonstrates how to use TIBCTable to work with data from a single table on the server without writing any SQL queries manually. Performs server-side data sorting and filtering and retrieves results for browsing and editing.
UpdateSQL Demonstrates using the TIBCUpdateSQL component to customize update commands. Lets you optionally use TIBCSQL and TIBCQuery objects for carrying out insert, delete, query, and update commands.
VirtualTable Demonstrates working with the TVirtualTable component. This sample shows how to fill virtual dataset with data from other datasets, filter data by a given criteria, locate specified records, perform file operations, and change data and table structure.

General Demos

Name Description
CachedUpdates Demonstrates how to perform the most important tasks of working with data in CachedUpdates mode, including highlighting uncommitted changes, managing transactions, and committing changes in a batch.
FilterAndIndex Demonstrates IBDAC's local storage functionality. This sample shows how to perform local filtering, sorting and locating by multiple fields, including by calculated and lookup fields.
MasterDetail Uses IBDAC functionality to work with master/detail relationships. This sample shows how to use local master/detail functionality. Demonstrates different kinds of master/detail linking, including linking by SQL, by simple fields, and by calculated fields.
Threads Demonstrates how IBDAC can be used in multithreaded applications. This sample allows you to set up several threads and test IBDAC's performance with multithreading.

InterBase-specific Demos

Name Description
Arrays Demonstrates working with InterBase arrays. This sample lets you view and control how arrays are represented in dataset fields by the SparseArrays and ObjectView properties.
BlobPictures Demonstrates working with InterBase BLOB data types. The sample shows how to get binary data from the table. Also it shows off some extended BLOB handling functionality like local caching control, deferred blob reading, getting blob subtype, and more.
DB_Key Demonstrates using Firebird 2.0 RDB$DB_KEY field for building SQLInsert, SQLUpdate and SQLDelete properties.
LongStrings Demonstrates IBDAC functionality for working with long string fields (fields that have more than 256 characters). Shows the different ways they can be displayed as memo fields and string fields.
TextBlobs Demonstrates working with InterBase BLOB data types. The sample shows how to get text data from the table. Also it shows off some extended BLOB handling functionality like local caching control, deferred blob reading, blob compression, getting blob subtype, and more.

Supplementary Demo Projects

IBDAC also includes a number of additional demo projects that describe some special use cases, show how to use IBDAC in different IDEs and give examples of how to integrate it with third-party components. These supplementary IBDAC demo projects are sorted into subfolders in the %IbDac%\Demos\ directory.

Location Name Description
ThirdParty FastReport Demonstrates how IBDAC can be used with FastReport components. This project consists of two parts. The first part is several packages that integrate IBDAC components into the FastReport editor. The second part is a demo application that lets you design and preview reports with IBDAC technology in the FastReport editor.
InfoPower Uses InfoPower components to display recordsets retrieved with IBDAC. This demo project displays an InfoPower grid component and fills it with the result of an IBDAC query. Shows how to link IBDAC data sources to InfoPower components.
IntraWeb A collection of sample projects that show how to use IBDAC components as data sources for IntraWeb applications. Contains IntraWeb samples for setting up a connection, querying a database and modifying data, and working with CachedUpdates and MasterDetail relationships.
ReportBuilder Uses IBDAC data sources to create a ReportBuilder report that takes data from InterBase database. Shows how to set up a ReportBuilder document in design-time and how to integrate IBDAC components into the Report Builder editor to perform document design in run-time.
Miscellaneous CBuilder A general demo project about creating IBDAC-based applications with C++Builder. Lets you execute SQL scripts and work with result sets in a grid. This is one of the two IBDAC demos for C++Builder.
FailOver Demonstrates the recommended approach to working with unstable networks. This sample lets you perform transactions and updates in several different modes, simulate a sudden session termination, and view what happens to your data state when connections to the server are unexpectedly lost. Shows off CachedUpdates, LocalMasterDetail, FetchAll, Pooling, and different Failover modes.
Midas Demonstrates using MIDAS technology with IBDAC. This project consists of two parts: a MIDAS server that processes requests to the database and a thin MIDAS client that displays an interactive grid. This demo shows how to build thin clients that display interactive components and delegate all database interaction to a server application for processing.
VirtualTableCB Demonstrates working with the TVirtualTable component. This sample shows how to fill virtual dataset with data from other datasets, filter data by a given criteria, locate specified records, perform file operations, and change data and table structure. This is one of the two demo projects for C++Builder.
IbDacDemo IbDacDemo [Win32 version of the main IBDAC demo project - see above]
© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback