Delphi Tutorial

he suite of eight data-aware components:

• TFIB_Database
• TFIB_Transaction
• TFIB_Dataset
• TFIB_UpdateSQL
• TFIB_Query
• TFIB_StoredProc
• TFIB_Generator
• TFIB_CreateAlterDrop

for direct access of Firebird databases (Interbase also, but tested only on Interbase ver. 7.5). The components are based only on my own, not seldom non-standard, ideas. I have created these components with minimum programming code (all DCUs weigh ONLY 308KB). Wherever the original Borland code was not optimal I have overriden it, but generally I’ve tried to take the maximum advantage of Borland code.

Continue Reading »

It is a combined component (DataSet, Provider, ClientDataSet and UpdateSQL). If you are used to use ClientDataset, you may want to specify sql statement for each Modify, Delete and Insert sql. This is provided by TMsDataAdapter. It also allows you to change your connection easily from ADO to DBX or IBX or BDE. You can change your connection bridge with minimal source change. Don’t forget that it works based on MIDAS.

Continue Reading »

Powerful component suite for creation Delphi/C++Builder applications with direct access to PostgreSQL databases without BDE and ODBC.

Top reasons to use PostgresDAC 2.x:

• PostgresDAC is a royalty-free product;
• 100% native Delphi code;
• PostgreSQL 7.x-8.x support;
• only 300-400 Kb are added to your .exe file;
• full compatibility with all the existing data-aware controls and report designers;
• full support of the BLOB fields;
• TDBImageEx component for JPEG images support included in the package for free (with sources);
• detailed help system and a lot of various demo applications;
• compatible with Pervasive Postgres;
• and much more.

Continue Reading »

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.

Continue Reading »

Accuracer Database System is a Windows / Linux cross-platform BDE alternative embedded Delphi database with SQL support for software developers working in Borland Delphi / C++Builder and Kylix .

Accuracer represents the next generation of our Delphi databases products line which started more than five years ago with such highly famous and respected product as EasyTable.

Continue Reading »

SQLMemTable is a simple and fast in-memory table and query for Delphi and C++ Builder. SQLMemTable includes three visual components:

• TSQLMemTable which is a fast and easy in-memory TTable replacement;
• TSQLMemQuery that provides a subset of SQL’92 operators;
• TSQLMemBatchMove which is very close to TBatchMove and supports almost all of its functionality.

SQLMemTable does not require BDE and provides all the TTable functions such as master / detail relationship, filtering, searching, sorting, blob fields, key and range methods, as well as some advanced features like blob fields compression and Unicode support.

Continue Reading »

The product is a Native OLE DB provider for access to all versions of InterBase and Firebird SQL-servers. Using IBProvider, you can create applications based on:

• All versions of Microsoft Visual Studio (5.x, 6.x, 7.x) including Microsoft Visual Studio .Net 2005, ADO.Net 2.0.
• C++ Builder and Delphi.
• Microsoft Office (including Microsoft Access) through the Visual Basic for Applications (VBA).
• ASP and ASP.Net for Web applications development.
• MS SQL Linked server and Business Intelligence (Intergartion, Reporting, Analisys services).

Continue Reading »

Database Access Components for SQLite: TASQLiteDB, TASQLiteQuery, TASQLiteTable, TASQLiteUpdateSQL.

Continue Reading »

TXLSFile is a Borland Delphi library for reading and writing of Microsoft Excel XLS files
It is based on direct reading and writing of files, and works without OLE Automation with Microsoft Excel.

VB and C++ developers may use OLE XLSFile COM objects library.

Continue Reading »

Components for fast access to MySQL, PostgreSQL, Microsoft SQL, Oracle and Interbase SQL servers without use add-ons, such as BDE / ODBC / ADO. Besides, the components - sources of data are compatible with standard TDataset and have a number of additional features.

Zeos Database Objects library consists of:

• Low-level plain API for access to client part of MySQL, PostgreSQL and Interbase
• Low-level class API for access to MySQL, PostgreSQL and Interbase
• TZXXSqlDatabase components for representation of database connection
• TZXXSqlTransact components for transaction management
• TZXXSqlQuery components for executing of SQL-queries and viewing/editing of the contents of simple and complex selects
• TZXXSqlTable components for viewing and editing of database tables
• TZXXSqlMonitor components for viewing of outgoing queries to SQL-servers
• TZUpdateSql components for changing/deleting/adding of queries
• TZBatchSql for executing of SQL-scripts.
• more…

Continue Reading »