Delphi Tutorial

MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll.

(more…)

Active SQL Query Builder is a visual query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface.

Features:

• Completely visual building of complex SQL queries.
• MS Access style and SQL Server style visual query building interface.
• User-friendly interface with drag & drop support.
• Powerful means of working with parameters.
• Working in offline mode, storing metadata in XML files.
• Delicate handling of user queries.
• Restricting access to unwanted objects
• Designing user-friendly query building environment
• Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQLite and ANSI SQL/92, 89 and 2003 dialects SQL syntax.
• SQL Formatter.
• Localization.
• Active Query Builder is a special component.

(more…)

InterBase Data Access Components (IBDAC) is a library of components that provides access to InterBase, Firebird and Yaffil database servers. IBDAC uses the InterBase client directly to connect to the server. The IBDAC library is designed to help programmers develop faster and cleaner InterBase database applications.

IBDAC is a complete replacement for standard InterBase connectivity solutions. It presents an efficient alternative to InterBase Express Components and the Borland Database Engine for access to InterBase.

(more…)

With these three components you access an Oracle database directly, skipping the Borland Database Engine only using (32 bits) SQL*Net. This gives you the following advantages:

• No distributing, installing and configuring the BDE
• No BDE overhead or trade offs: your queries will run up to five times faster
• The program executable size will be more than 100K smaller
• The use of variants makes programming easy (null values, runtime type information)
• You can use PL/SQL blocks for server logic in your application
• Easy to use, the components are intelligent.

(more…)

ElevateDB is an embedded SQL database engine that can be compiled directly into your application* and offers local single and multi-user access (file-sharing) and client-server access with the provided ElevateDB server. ElevateDB can switch between these modes of operation quickly, requiring just a few application changes. ElevateDB adheres to a subset of the SQL 2003 standard (ANSI/ISO 9075).

(more…)

The DBISAM Database System is a proprietary database system designed from the ground up to merge the best features of the various local database formats available for the Delphi developer. DBISAM is targeted at the Delphi developer developing applications for single-user and multi-user use with heavy distribution requirements (such as shareware or downloadable software) or for small inhouse installations on a LAN such as Novell Netware, Windows NT, LANtastic, or Windows 95 networking.

(more…)

FIBPlus is the simplest and most flexible suite of components for direct access to FireBird and Interbase. Full support of SQLDialect 3 of Interbase / FireBird, support of array-fields, emulation of boolean fields, multi-table and multi-transaction modification of data. Support for InterBase 2007 added.

(more…)