Home | 10% - Off! | New | VCL | DB-Aware | Tools | DB Tools | Apps | Samples | .NET | .NET DB-Aware | .NET Tools | .NET Samples | Kylix | Docs | Bold | Discussion | Sites | Tips | DPFL | Authors | Uploads | RSS | Store | Advertisement | About
DB-Aware Components

DB Access
Export and Import
Direct DB Access
DB-Aware Components > DB Access > SQL  

Companies News:

New Rosi Components Package released
New Rosi Components Package released Create feature-rich windows applications with many new components and universal dialogs.
  • improved DBGrid
  • new DBRecordView, DBTreeView
  • toolbars and db dialogs to Find, Filter, Sort, Export, Print...
  • StringGrid with columns definition
  • GroupBox with automatic alignment and resizing of owned controls
And many more for $35 only - details here
Want to know more ?


SQL Parser v.4.0.01GPLS 453 k 19 Oct 2011
By Fundamentals Library.
  • Fast SQL lexer
  • Complete SQL92 implementation
  • T-SQL extensions, SQL99 and SQL2003 (partially).

Fully functional
Source: Included
Download: D2005 D2006 D2007 D7  Homepage

InstantBDExpress v.1.8.8C 1706 k 14 Sep 2010
By Ethea. InstantBDExpress (IBDX) is a dbExpress-based component library that emulates the behavior of the BDE components, plus an array of techniques and methodologies to integrate these components in existing (possibly huge) applications.

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

Download: D2006 D2007 D2009 D2010 D6 D7 DXE  Register NowHomepage

TMsDataAdapter v. 990 k 12 Apr 2009
By Mohammad Sanati. 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. Remember that it works based on MIDAS.
With Nag-Screen
Source: On purchase/registration
Price: $9
Source Price: $9
Exe-Demo Included
Download: D2007  Homepage

Database Access Components for SQLite v.2008.06.DFWS 2168 k 04 Jun 2008
By Aducom Software. Database Access Components for SQLite: TASQLiteDB, TASQLiteQuery, TASQLiteTable, TASQLiteUpdateSQL.
Fully functional
Source: Included
Download: CB5 CB6 D2005 D2006 D2007 D4 D5 D6 D7  Homepage

EzQuery Dialog v.1.0FWS 3036 k 28 May 2008
By John Clark Clark. TQueryDialog that dynamically creates a query dialog from either a TForm, TDBGrid or TDataSet. It is great for end-user database applications where the user needs an easy method to search for database records. Save hours of coding.

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.
Supports syntax for filters or SQL. Easy to use. Just drop the component on the form or data module and call the Execute method. Supports both modal dialog and Midi child forms.
Fully functional
Source: Included
Exe-Demo Included
Download: CB1 CB2k6 CB3 CB4 CB5 D3 D4 D5  Homepage

oksDBQueryBuilder v.1.2FW 302 k 16 Mar 2007
By olkrosoft. oksdbQueryBuilder represents the ideal addition for oksdbEngine. oksdbQueryBuilder allows developpers and users building complex SQL structures by visual joining tables or table fields.

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.

Fully functional
Source: None
Download: D2005 D2006 D7  Homepage

Ga SQL Parser v.0.15 alphaFWS 232 k 20 Jun 2006
By Gert Kello. A string parser that is capable to parse SQL statements into tokens, allows changing theese tokens and rebuilding (modified) SQL statement.

Consists two components:

  • gaBasicSQLParser
  • gaAdvancedSQLParser.

Fully functional
Source: Included
Download: D5 D6  Homepage

SuperFastDistinct v.1.0CS 5720 k 18 May 2006
By Grebar Systems Inc.. SuperFastDistinct. is the fastest way on the planet to obtain all the distinct values from a table. All you need is a TTable (or equivalent) and an index on the field(s) you wish to retrieve.
  • 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:

Select distinct col1 [,col2,col3] from Table1 order by col1 [,col2,col3]

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.


  • 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.
Download our benchmark demo and see the speed improvements for yourself.
Demo only
Source: Included
Price: $89
Exe-Demo Included
Download: CB2k6 CB4 CB5 CB6 D2005 D2006 D4 D5 D6 D7  Homepage

InFormQuery Component v. 39 - 41 k 06 Apr 2006
By Miguel Guzman. This is the Delphi component for ad-hoc queries you was looking for, forget complicated forms to enable non-planed queries to your end user, just drop this component into your data-entry forms and you will unleash the power to your end users.

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

Download: D5 D6 D7  Register NowHomepage

SchSQLBuilder v.1.1FWS 171 k 05 Dec 2005
By Gabor Schneider. Simple SELECT SQL script builder from field-, table- and where info.


  • 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.

Fully functional
Source: Included
Exe-Demo Included
Download: D3 D4 D5 D6 D7  Homepage

TeMeL_SQLParser class v.1.05FWS 4 k 23 Jun 2005
By eMeL. This class an ANSII C++ code for parse and decompose a select SQL statement.

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

Download: CB1 CB3 CB4 CB5 CB6  Homepage

dbConnect v.1.0C 56 k 22 Apr 2005
By cioosoft.de. Add to your Delphi/Firebird applications a comfortable connection-dialog similar to the Delphi IDE.

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


  • 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).

Demo only
Source: None
Price: $25
Exe-Demo Included
Download: D2005 D5 D6 D7  Homepage

IB/FB Managers plugin v.0.23FW 61 k 03 Mar 2005
By Sergey Pfaffenrot. Plug-in For Delphi. It allows to be connected to database Interbase/Firebird and to carry out SQL-inquiries directly in IDE.


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

Fully functional
Source: None
Download: D7  Homepage

libsql v.0.41FWS 48 k 14 Sep 2004
By rene. Libsql is an object wrapper around SQLLite and MySQL.

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.


  • 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.

Fully functional
Source: Included
Download: D3 D4 D5 D6 D7  Homepage

SQL Set v.1.03FWS 23 k 14 Jun 2002
By Technical Street Software. Component for construction of list of SQL queries, editable in the property editor at design time, with possibility of insertion of variables in query, which can be replaced by any string value at run time.

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

Download: D3 D4 D5 D6  Homepage

SQLDump v.1.0FWS 5 k 14 Oct 2001
By Gideon Vos. TSQLDump creates SQL INSERT statements from data in active dataset. Great for creating data backups and data-replication tools.
Fully functional
Source: Included
Download: D3 D4 D5  Homepage

IBXSQLEditor v.13bFWS 48 k 18 Sep 2001
By Andrew Semack. Enlarged SQL Editor for IBX components. This version is also compatible with FIBPlus Components.


  • 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.

Fully functional
Source: Included
Download: D5 D6  Homepage

TFilterSQL v.1.0FWS 10 k 29 Aug 2001
By Dmitry Yatcenko. Runtime filtering SQL query builder. Required TFilterFieldLink, TDecimalEdit components (included).
Fully functional
Source: Included
Download: D5 D6  

SQL Parser v.1.1FWS 16 k 01 Mar 2001
By Kei. TQueryParserComp is a simple text parser which recognizes comments, strings, statement delimiters and special characters.
Fully functional
Source: Included
Download: D5  

CJ Interbase Components FWS 6 k 01 Mar 2001
By Licom Systems. Contains:
  • TCJIBDataset - Additional functionality added to a TIBDataset
  • TCJIBQuickSearch - Efficient Incremental Searching
  • TCJIBSortCombo - Allow users to change the sort order of the dataset.

Fully functional
Source: Included
Download: D5  Homepage

PrIBSQLScript v.0.01FWS 288 k 17 Apr 2000
By Consys. Execute multiple SQL statements using IBX components.
Fully functional
Source: Included
Download: D5  

TMultiUpdate SQL v.1.1FWS 21 k 11 Jan 2000
By Skybound Software. This component is similar to the TUpdateSQL component but is capable of executing multiple statements in one step. A help file is included with a more detailed description.
Fully functional
Source: Included
Download: D3 D4 D5  Homepage

TSQLList v.0.1FWS 6 k 29 Sep 1999
By Anthony Zanetti. The TSQLList component makes it possible to store 10 SQL requests. For each request one can define the author, the creation date and a description on the request. One associates TQuery with TSQLList and one can choose one of the 10 requests which will be carried out by TQuery with the ActiveSQL property.
Fully functional
Source: Included
Download: D2 D3 D4 D5  

TUpdate Multi v.2.0FWS 14 k 03 May 1999
By Cogisoft. The UpdateMulti component is similar to Delphi's UpdateSQL component, but it is able to update multiple tables.
Fully functional
Source: Included
Download: D2 D3 D4  Homepage

FRSQL Tracer v.1.0FWS 16 k 30 Mar 1999
By FrontRunner Technologies. The TFRSQLTracer component allows you to provide SQL Monitor functionality to your end-users. There are basically three parts to the component. The component itself captures all the same information as SQL Monitor. In addition, it will fire an event whenever any message is generated. This will allow a developer to display the messages however he/she chooses. There is also built-in handling of the messages, in which case the event can be used as an additional filter for the incoming messages. All messages are stored internally by the component, and can be viewed at any time by calling the ShowTraceForm procedure. This lists the messages similar to how SQL Monitor lists them, with a little added information.
Fully functional
Source: Included
Download: D3 D4  

News from our Sponsors

  Active Query Builder VCL Edition is a visual query designer and SQL parser component for WinForms, WPF, ASP.NET, Delphi/C++Builder and Java
Active Query Builder VCL Edition is a visual query designer and SQL parser component for WinForms, WPF, ASP.NET, Delphi/C++Builder and Java Active Query Builder allows users to build SQL queries via the intuitive drag'n'drop interface and to edit them via the powerful text editor with code completion and syntax highlighting, combining these techniques in any order. It lets parse, analyze and modify complex SQL queries programmatically. It supports tens of SQL language dialects: Oracle, SQL Server, MS Access, MySQL, PostgreSQL, etc. Active Query Builder provides highly productive environment to work with SQL queries for both the end-user and programmer! more... more...

  Add perfect security to your application !
SecureBlackbox is a suite of software components that allows developers to add strong security to their applications to protect binary data, files, documents and e-mails. SecureBlackbox includes authentic implementations (no 3rd-party code used) of various data security standards and network communication protocols for various platforms (Windows, .NET, Linux, MacOS X / iOS, Java / Android). more... more...

Advertising on Torry's Delphi Pages


Sort order
Quick Search
Exact phrase

Advertising on Torry's Delphi Pages

Guest Book
Guest Book

Sign-up for Torry newsletter
and get free component pack !



Subscribe to news in RSS 2.0 format!Subscribe to news in RSS 2.0 format!
Bookmark and Share
Up | Home | 10% - Off! | New | VCL | DB-Aware | Tools | DB Tools | Apps | Samples | .NET | .NET DB-Aware | .NET Tools | .NET Samples | Kylix | Docs | Bold | Discussion | Sites | Tips | DPFL | Authors | Uploads | RSS | Store | Advertisement | About
Copyright © Torry's Delphi Pages Torry's Delphi Pages Notes? Comments? Feel free to send...

The Ultimate Source of Object Pascal and Delphi Programming Knowledge.

Copyright © 1996-2015
All trademarks are the sole property of their respective owners
Privacy Policy