Developer's Guide

Go Up to User Guides

This guide covers the "how-to" information on developing InterBase database applications using Embarcadero development tools, JDBC, and ODBC. Topics include:

• Connecting to databases
• Understanding datasets
• Working with tables, queries, stored procedures, cached updated and events
• Working with UDF and Blob filters
• Importing and exporting data
• Working with InterBase Services
• Writing install wizards

Chapters

Chapter	Description	Topics
Using the InterBase Developer’s Guide	Intended audience and coverage
Client/Server Concepts	Architecture of client/server systems using InterBase, including the definition of client and server, and options for application development.	Definition of a Client The InterBase Client Library Definition of a Server Application Development
Programming Applications with Delphi or C++Builder	Describes how to attach to and detach from databases, and how to request information about attachments.	Optimizing the InterBase SQL Links Driver Working with TQuery Using Generators with ODBC
Programming with JDBC	Building InterBase applications using InterClient, InterServer, and JBuilder.	Installing InterClient Classes into JBuilder Programming with InterClient Developing InterClient Programs Troubleshooting InterClient Programs Deploying InterClient Programs InterClient/JDBC Compliance Specifications InterClient Data Source Properties for InterBase InterClient Scrollability Batch Updates Implementation of Blob, Clob, and Other Related API's
Programming Applications with ODBC	Programming InterBase applications with ODBC and OLE DB; programming with the ODBC driver, and configuring and using ODBC data sources.	Overview of ODBC Configuring and Using ODBC Data Sources
Working with UDFs and Blob Filters	Working with UDFs: UDF libraries, declaring the functions to the database, calling the functions; working with Blob filters.	UDF Overview Writing a Function Module Compiling and Linking a Function Module Declaring a UDF to a Database Calling a UDF Writing a Blob UDF The InterBase UDF Library Declaring Blob Filters
Designing Database Applications	Designing a database application, including the decisions involved in designing a user interface, how to use databases and database architecture.	Using InterBase Databases Database Architecture Designing the User Interface
Building Multi-tiered Applications	Understanding the elements of a database application, including datasets and transactions.	Understanding Databases and Datasets Scaling Up to a Three-tiered Application Creating Multi-tiered Applications
Introduction to IBX	Using InterBase Express (IBX) data access components.	Getting Started with InterBase Express
Connecting to Databases	Database components and how to manipulate database connections.	Persistent and Temporary Database Components Controlling Connections Requesting Information about an Attachment
Importing and Exporting Data	Using IBX components to migrate data to and from a database.	Exporting and Importing Raw Data Exporting and Importing Delimited Data
Working with InterBase Services	Building InterBase services into your applications.	Overview of the InterBase Service Components Setting Database Properties Using InterBase Services Backing up and Restoring Databases Performing Database Maintenance Requesting Database and Server Status Reports Using the Log Service Configuring Users Displaying Server Properties
Programming with Database Events	Using an IBX TIBEvents component to manage InterBase server events.
Working with Cached Updates	Working with cached updates and using the TIBUpdateSQL component to update datasets.	Deciding When to Use Cached Updates Using Cached Updates Using Update Objects to Update a Dataset Updating a Read-only Dataset Controlling the Update Process Handling Cached Update Errors
Understanding Datasets	Working with datasets and TDataSet	What is TDataSet? Opening and Closing Datasets Determining and Setting Dataset States Navigating Datasets Searching Datasets Modifying Dataset Data Using Dataset Events Using Dataset Cached Updates
Working with Queries	Working with datasets and TDataSet.	Queries for desktop developers Queries for server developers When to use TIBDataSet, TIBQuery, and TIBSQL Using a query component: an overview Specifying the SQL statement to execute Setting parameters Executing a query Preparing a query Unpreparing a query to release resources Improving query performance Working with result sets
Working with Tables	Working with tables and TIBTable.	Using table components Setting up a table component Controlling read/write access to a table Searching for records Sorting records Specifying fields with IndexFieldNames Working with a subset of data Deleting all records in a table Deleting a table Renaming a table Creating a table Synchronizing tables linked to the same database table Creating master/detail forms
Working with Stored Procedures	Using InterBase stored procedures in your database applications.	When Should You use Stored Procedures? Using a Stored Procedure Understanding Stored Procedure Parameters Viewing Parameter Information at Design Time
Debugging with SQL Monitor	Using TIBSQLMonitor to monitor the dynamic SQL passing through the InterBase server.	Building a Simple Monitoring Application
Writing Installation Wizards	Using TIBSetup, TIBInstall, and TIBUninstall to build an InterBase installation program	Installing Defining the Uninstall Component