• TCJIBDataset - Additional functionality added to a TIBDataset
• TCJIBQuickSearch - Efficient Incremental Searching
• TCJIBSortCombo - Allow users to change the sort order of the dataset.

It automatically generates the query dialog using any data-aware controls including:

• DBGrid
• DBListBox
• DBComboBox
• DBCheckBox
• DBRadioGroup
• DBEdit
• DBLookupComboBox
• DBLookupListBox
• DBCtrlGrid
• TTable
• TQuery
• Any data aware component.

Consists two components:

• gaBasicSQLParser
• gaAdvancedSQLParser.

Requirements:

• Library FIBPlus 6.1 and editors;
• Presence of Delphi 7 IDE.

Features:

• Preparation of queries, setting of parameters and executing of SQL expressions.
• Error reports, highlighting of syntax, work with transactions.
• Extracting metadata for tables, views and stored procedures.
• Drag and drop of tables elements and views from a special list.
• Viewing of plans and query results.
• Automatic definition of the type of an SQL expression (Open or Execute).
• Checking of expressions on a special laying.
• Saving of a self position in Registry.
• Extracting of metadata both for a set element and the whole database.
• Saving of metadata to a disk.

It is so easy to use, just press the "Start Query" button, all the data enabled controls will change temporary to a query controls that allow the use of query sentences like lists, example (CA, OR, NY), ranges 100..200, logical operators >=, <=, <>, negation (.). Then press the "Execute query" and the component bring the records that meet the condition requested.
 
Trial (work while IDE is running)
Source: On purchase/registration
Price: $49.90

The documentation explains techniques useful to inject IBDX in an existing application for easy transition: the application keeps working with the BDE while it is being converted.
 
Fully functional
Source: On purchase/registration
Price: $320

• Fast SQL lexer
• Complete SQL92 implementation
• T-SQL extensions, SQL99 and SQL2003 (partially).

Required components: Dinamic List and Text Reader.
 
Fully functional
Source: Included

Features:

• Cannot add any item with empty name
• Fields must be TABLENAME.FIELDNAME format (case insensitive, without spaces)
• Aliases can contain special character, space, etc.
• Field items have alias and aggregate informations (TSchFieldDef and TSchAggregate)
• Table items have alias informations (TSchTableDef)
• OrderBy items have sort order informations (TSchOrderByDef and TSchOrderBy)
• You can use English or Hungarian language.

• Up to 5x, 10x, 100x faster than SQL
• Over 500x faster than SQL on large LAN based tables over the network (non-Client/Server)
• Uses up to 1,000x less memory than SQL on large tables compared to database engines like Paradox and others.
• Prevent computer slow downs and disk thrashing. Improve network throughput.
• Super easy. Requires only 1 line of code.

A single call to our SuperFastDistinct() procedure is 5x, 10x, even 100x faster than the SQL statement that it replaces:

Your users will no longer have to stare at the hourglass while the slow SQL distinct query completes. SuperFastDistinct. can give you the distinct values 5x, 10x to 100x faster than SQL. All you need is an index on the field(s) and our proprietary algorithm will traverse the index to return the distinct values in sub-second speeds even on million row tables. Not only will this make your users happy, but your web server or database server can support more users without consuming vasts amounts of memory.

Features:

• SuperFastDistinct. works with embedded databases, single user databases, multi-user LAN databases, Client/Server databases, and in-memory tables. Anywhere you can use a Table component, you can use SuperFastDistinct..
• SuperFastDistinct. works with any index, including compound indexes.
• Let’s say you have an index made up of the fields: Country, State, City. You have a choice of retrieving the distinct Countries, or the distinct Country & State combinations, or the distinct Country & State & City combinations. (You must choose one or more of the leading index fields. You can’t get distinct Cities from this compound index because the index does not start with City. You would need to create another index on City if you want just the distinct cities.)
• Add a Filter or a Range to get a subset of distinct values from the table.
• SuperFastDistinct. is thread safe.
• Save the distinct values to any TStrings object like a TComboBox, TListBox, TMemo, or to another database table or even to a memory table like kbmMemTable etc..
• The results are automatically sorted in index order.
• Unlike SQL, SuperFastDistinct. will not consume a lot of memory and will run fast even on machines with very little memory. Memory consumption is extremely low.
• SQL engines like Paradox/BDE can consume vast amounts of memory when retrieving the distinct values from a large table. During our benchmark tests, some of the SQL engines consumed over 100 MB of memory when retrieving the distinct values from a 1 million row table. By comparison, SuperFastDistinct. used only 1 kilobyte of memory to retrieve the same distinct values from the same 1 million row table.
• SQL is not required. If your database doesn’t support SQL, that’s fine because SuperFastDistinct. doesn’t use SQL. SuperFastDistinct. works on any TTable component or 3rd party table component like DBISAM, Advantage, NexusDb, dbExpress, and even kbmMemTable. Support for other databases can be added by the user and we will be releasing support for more databases over the next few months.
• SuperFastDistinct. comes with complete source code.
• Works with IntraWeb(TM) from AtoZed and most web based applications that can compile Delphi code.
• SuperFastDistinct. is 100% Delphi code and runs on Delphi 4 through Delphi 2006 Win32 and Delphi Vcl .NET. All of the SuperFastDistinct. code is stored in a single Delphi unit called SuperFastDis.Pas. There are no DLL’s or additional files to install to your client’s machine. SuperFastDistinct. gets compiled directly into your .exe file. Getting super fast distinct values from your table is just one function call away.
• No royalties.

You can modify any tag of statement and rebuild SQL command. It's an easy way to modify SQL text before execute.

This class is very clear and easy of use. Naked ANSII C++ code for portable applications. It use very few resources and very quick.
 
Fully functional
Source: Included
Exe-Demo Included

Component to save database connection-parameters of Firebird/Interbase.

Features:

• creates and manages ini-file automatically
• dialog-captions can be set in Objectinspector (multiliguality)
• no sourcecode editing necessary.

• Borland Delphi (version 7 tested)
• Interbase Express Component (version 7.08 tested).

At current state, libsql support sqlite 2.8 and sqlite 3; mysql 4.0 and embedded mysql 4.0. The library is targeted to be compatible with Delphi 4+, Kylix and FreePascal (Both windows and Linux).

The novelty about libsql is the very fast and convenient way to perform queries and to access your result set.

Libsql provides two classes (TLiteDB and TMyDB) to access the database. Both classes are derived from same ancestor, so quering syntax is almost identical. Results are fetched in memory and/or per row on callback-based method ("event"). Object interface provides flexible interface with very little code.

Libsql is particulairy suited for situations where you need quick and easy access to a database (as easy as you would access an ini file), while maintaining full functionality of the database. it does not provide an interface to data-aware components, but the easy quering methods make it not hard to implement it in a GUI.

Libsql supports multi-threaded applications. that is: your application can be threaded. libsql is not threaded itself. if you want threaded (background) db access with event-oriented results, please use another library like TMySQL instead.

Features:

• full multi-threading support
• dynamic dll loading
• quick, simple and flexible database access while maintaining full functionality
• object structure makes it easy to implement an application not worrying about memory (leaks) or exceptions
• suited for gui- and console applications and services.

Some Highlights:

• NonVCL-Component for Borlands Delphi since Version 7
• Generating SQL-Joins visually via Drag & Drop
• Generating calulated fields for each table
• Easy generating complex SQL-92 structures visually
• Full SQL-92 compatible.