Delphi 7.0x freeware [Data Base Programming]

Delphi 7.0x freeware
Data Base Programming

[ 1dnav_d7.zip ] [ 423,900 bytes ]

[ Freeware ] [ No Source ]
[ D7 ]

Data Navigator contains a set of components for data searching and filtering different databases. The package includes a collection of non-visual components and a collection of visual components. Non-visual components are designed for filtering or searching for data in different dataset components. Visual components are designed for data entry by an end-user, in this case non-visual components of this package will filter or search required data. This package gives you the following advantages:

The filtration and search for the required data can be of any level of difficulty.
Optimization of search and filtration taking into account a current index.
SQL filtration. Use "WHERE" clause to limit the effect of a SELECT statement to a subset of rows in the table.
Support of BDE, MIDAS, ADO, dbExpress, InterBase Express, etc.
Support alternative database access: DBISAM, KeyDB, KbmMemTable, etc.
Development of VCL and CLX applications.
A broad set of visual components designed for data input by an end-user for the search and filtration of data.
Simple integration with any other visual components designed for data input.
Simple integration with any dataset components developed by other producers.

Our package gives you a very powerful set of components for organizing data searches and filtration in your application. The division of the package into a set of visual and non-visual components gives you maximum flexibility when building applications. We offer you the best set of components in this field and hope that you will enjoy our software product.
Data Navigator is currently available in Catalan, Chinese, Czech, Dutch, English, Farsi, Finnish, French, German, Greek, Hungarian, Italian, Norwegian, Polish, Portuguese, Romanian, Russian, Serbian, Slovak, Slovenian, Spanish, Swedish, Turkish and etc. languages.

Added: 18-03-2003/18-08-2003 | Version: 1.04 | Downloads: 3115/3051/34

Author:

IMG Software [Homepage] [DSP files]

Compatible files: [ D4 | D5 | D6 | C4 | C5 | C6 ]

[ AJB_ADOItems.zip ] [ 35,180 bytes ]

[ Freeware ] [ With Source ]
[ D7 ]

These Extended ADO Components make it easier to program with ADO databases.

TAJB_ADOConnection

TADOXCatalog

Many methods are provided to give information about and manipulate views, tables and procedures within the database.

Latest version fixes some problems with compacting / repairing databases as well as disconnected recordsets.

Added: 15-03-2004/6-04-2004 | Version: 3.0 | Downloads: 1717/1703/23

Author:

Andrew Baylis [DSP files]

[ aqb_free.zip ] [ 3,673,756 bytes ]

[ Freeware ] [ No Source ]
[ D6 | D7 | C6 ]

Active Query Builder is a query builder component suite for Borland Delphi and C++ Builder which gives your end-users the ability to create complex queries with unions, subqueries and nested joins via the intuitive visual interface. It can be integrated with your application by setting a few properties or a few lines of code. Free Edition supports only ANSI-92 SQL dialect.

Added: 8-08-2005/24-08-2005 | Version: 0.9.7 | Downloads: 245/245/20

Author:

Sergey Smagin Active Database Software [Homepage] [DSP files]

[ avibqry.zip ] [ 1,981,448 bytes ]

[ Freeware ] [ No Source ]
[ D6 | D7 ]

Improvement of the standard IBX IBQuery component for Delphi with all his original functionality plus a set of new features that convert it in a powerful partner of the programmer. This allow you to create queries in ease way and give to the end-users the chance of modify it through an intuitive interface using a natural end-user language. They have not need to know the SQL language, they don't see the real tables and field names, you enter descriptive names for tables and fields that the end-user can understand, besides all text messages including the logical operators like (=,<>, >, <, >=, etc.) can be changed by descriptive phrases like "is not equal to". Demo programs with exes included and documentation in english and spanish languages. Standard edition $29.95 Developer edition (all sources included) $59.95

Added: 2-11-2005/7-11-2005 | Version: 1.0.1 | Downloads: 136/136/13

Author:

Alcides Valega [Homepage] [DSP files]

[ awvsqlbrowsedir11.zip ] [ 13,932 bytes ]

[ Freeware ] [ With Source ]
[ D7 ]

TawvSQLBrowseDirDlg is a Delphi 7 component for browsing the directory tree structure of a machine hosting Microsoft SQL Server or MSDE. It uses ADO to establish a connection and the undocumented stored procedures "xp_fixeddrives" and "xp_dirtree" to fetch the list.
Demo included.

Added: 3-05-2004/10-05-2004 | Version: 1.1 | Downloads: 988/974/12

Author:

Andrew Venmore [DSP files]

[ btrutils.zip ] [ 69,495 bytes ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | D6 | D7 | K1 | K2 | K3 ]

Product "BtrUtils Library for Delphi" is designed for using native Btrieve API in applications created with Borland Delphi. [more]

Added: 8-12-2003/25-04-2004 | Version: 1.0.5 build 38 | Downloads: 2018/2018/26

Author:

Alexander Leonov [Homepage] [DSP files]

[ edbimg16.zip ] [ 26,482 bytes ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | D6 | D7 ]

EDBImage is a replacement for DBImage. Store .jpg .wmf .emf .ico .bmp in your database WITHOUT a line of code. Other formats can be stored from an event (ANY other format). QREDBImage is the QR printable version of EDBImage. Easy of use, try it now!.
Any database supported (Interbase, SQLServer, MSAccess,etc).

Added: 16-11-2004 | Version: 1.6 | Downloads: 1539/1539/44

Author:

Sebastián Mayorá Sebastián Mayorá [Homepage] [DSP files]

[ EstSearchDialog.zip ] [ 146,839 bytes ]

[ Freeware ] [ With Source ]
[ D6 | D7 ]

Use Erik Stok search dialogs to easily create powerful search functionality in your application by simply building an SQL statement and visualy configuring how your user may search on the query result. You can create search dialogs for BDE, DB Express, ADO, Interbase Express, Zeos, Flashfiler and Nexus DB. Or you can create your own descendant with the freely available sourcecode.

Added: 26-01-2004 | Version: 1.0 | Downloads: 2048/2048/28

Author:

Erik Stok [Homepage] [DSP files]

[ etvspg.zip ] [ 328,666 bytes ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | D6 | D7 ]

Etv Pages contains TEtvPageControl and TEtvTabSheet. Turn off the data on inactive pages to increase speed. It can turn off dbaware control from datasource and detail dataset from master. Choice of active TabSheet is added to Popup menu of TEtvPageControl, as it is complicated seldom from other controls.

Added: 9-04-2000/18-03-2003 | Version: 3.5 | Downloads: 3931/3929/10

Author:

Frants Ivanouski Etv Software [Homepage] [DSP files]

[ link: savcl_me.zip ] [ size n/a ]

[ Freeware ] [ With Source ]
[ D6 | D7 ]

SaVcl - library of Delphi VCL components for direct access to Sybase Anywhere databases. Features: freeware with sources; direct access via Sybase Anywhere API; no ODBC, ADO, BDE, etc are used; SQL-monitor; dynamic row fetching; no Sybase Anywhere installation is requaried; multithreading; correct sorting of the null fields; cached updates; transaction, bookmarks and data of large size are supported; filters with nested levels of any depth; extended searching including "find forward", "find backward"; inserting rows into cursors; etc;

Added: 2-06-2003 | Version: 1.12 | Downloads: n/a

Author:

Serge Gavrilov [Homepage] [DSP files]

[ link: ] [ size n/a ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | D6 | D7 | C3 | C4 | C5 | C6 ]

B-Tree Filer is a fast library of file-based database routines for Borland Turbo Pascal & Delphi. B-Tree Filer supports stand-alone programs or those running on Microsoft-compatible networks including Novell Netware.
released under Mozilla Public License 1.1 (MPL 1.1)

Added: 4-02-2003 | Version: 5.55 | Downloads: n/a

Author:

TurboPower B-Tree Filer Project (Sourceforge) [Homepage] [DSP files]

[ link: ] [ size n/a ] [ Freeware ] [ With Source ]
[ D4 | D5 | D6 | D7 | C5 | C6 | K1 | K2 | K3 ]

ZeosDBO is a database middleware components for Borland development tools, including Delphi, C++ Builder and Kylix.

The following compilers are supported:

Delphi 4 - 7
C++ Builder 4 - 6
Kylix 1 - 3

ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface:

MySQL 3.20 - 4.1
PostgreSQL 6.5 - 7.3
Firebird 1.0 - 1.5
Interbase 5.0 - 7.5
Microsoft SQL Server 7, 2000
Sybase ASE 12.0, 12.5

For other databases we propose to use implemented Active Data Objects (ADO) Bridge.

Advantages of using ZeosDBO:

Platform independance. The ZeosDBO is highly generic. Applications written in ZeosDBO can be migrated across databases without major changes.
ZeosDBO is open source, written for usability and extensibility.
ZeosDBO leverages the amazing power of the Delphi development environment without relying on a performance killing middleware.
ZeosDBO is an extremely thin abstraction layer, unlike 'thick' layered protocols like ADO and BDE.

Package contents:

ZCore - Core classes and interfaces. Contains Java style objects and collections as well as compatibility types and functions.
ZParseSql - SQL specific for syntax and lexical analysis.
ZPlain - Native plain API to supported SQL servers.
ZDbc - Port of Java Database Connectivity API (JDBC 2.0). DBC API acts as intermediate layer between Plain API and highlevel TDataset or DBExpress components.
ZComponent - visual components descended from TDataset.

Installed components:

TZConnection: This component encapsulates the database connection and transaction management.
TZReadOnlyQuery: TDataset component to execute SQL queries and process data in read-only mode.
TZQuery: TDataset component which allows data modifications in regular and cached mode.
TZUpdateSQL: Analog of standard TUpdateSQL component to explicite definition of Insert/Update/Delete SQL statements for TDataset modifications.
TZStoredProc: The component to execute SQL stored procedures.
TZSQLProcessor: The component to execute SQL scripts for different SQL and various delimiter types.
TZSQLMonitor: The component to monitor all outgoing SQL queries and other logging information.
TZSQLMetadata: Specialized TDataset component which provides an access to database metadata such as tables, columns, indices, etc.

The project home page is here (for news, links and other project info): http://www.zeoslib.net

The sourceforge development site is located here (for technical resources and anonymous web based cvs access): http://www.sourceforge.net/projects/zeoslib

Added: 21-03-2001/9-02-2004 | Version: 6.1.3 beta | Downloads: n/a

Author:

ZeosLib team [Homepage] [DSP files]

[ link: sqlmemtable_spec.php ] [ size n/a ]

[ Freeware ] [ No Source ]
[ D4 | D5 | D6 | D7 | C4 | C5 | C6 ]

AidAim SQLMemTable - FREE! SQLMemTable is a fast and easy-to-use in-memory table and query VCL for Delphi and C++ Builder. SQLMemTable includes two visual components: TSQLMemTable, which is a fast and easy in-memory TTable replacement; TSQLMemQuery that provides a subset of SQL'92 operators. 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. SQLMemTable provides the following services: SQL (DML & DDL) commands support; master / detail relationship; creating, renaming, emptying, deleting and restructuring tables; creating, editing, deleting, browsing and searching for records; creating and deleting multiple indexes; calculated and lookup fields; filtering support; BLOB fields compression; importing from and exporting to any dataset in fast and easy way; internationalization / localization and Unicode support. SQLMemTable is a fully functional in-memory database system; it includes table and query components as well as useful utility (with source code), demos and comprehensive help. SQLMemTable does not require BDE or any external drivers and has small footprint. Features and benefits: Compactness - Short compiled code with approximate size 300 Kb, no external drivers (such as BDE) required. - Small memory consumption by SQLMemTable database engine. - Fast BLOB data compression. Your large data fields will need less memory. SQLMemTable can compress data on the fly. The compression routines used in the SQLMemTable are much faster than most of popular archivers like PKZip, WinRar, Arj. High performance - Fast search by B-tree indexes. At the moment SQLMemTable is one of the fastest existing in-memory tables for Delphi and C++ Builder. - High-speed in-memory performance is achieved by means of using specially optimized memory manager and tuned algorithms. - Quick operations with strings. SQLMemTable compares strings up to 3 times faster than standard Delphi string routines. High performance is achieved by using a special library written in Assembler and an advanced sorting algorithm. - Advanced SQL optimizer often makes query execution significantly faster by choosing the best execution plan. Functionality - A subset of SQL'92 (DML & DDL) operators is supported by TSQLMemQuery component. With SQLMemTable you can create SQL scripts for creating tables, inserting, editing and deleting records, retrieving data by SELECT command. See full list of supported commands. - Advanced search engine. SQLMemTable supports 'LIKE' operator with wildcards '%' and '_', as well as 'IS NULL' and 'IS NOT NULL' in filters and queries. - Full multiple index support, i.e. numerous fields in a table may comprise an index. SQLMemTable provides descending and ascending indexes, case-sensitive and insensitive indexes for string fields. - Shareable in-memory tables. SQLMemTable supports simultaneous access to a table by multiple TSQLMemTable components within a single application. - Default values support. - Record-level constraints, i.e. constraints that must be met when editing the data. Compatibility - SQLMemTable supports most of TTable field data types, including BLOB fields, moreover it allows to create string and wide string fields of any fixed length. - SQLMemTable is fully compatible with standard DB-aware visual controls such as QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit, as well as with third party products supporting TDataset descendant components - FastReport, DBFlyTreeView and others. - Calculated and lookup fields can be used in the same way as TTable. - Most of TTable functions are supported including Key and Range methods. Convenience - Table restructuring is being performed in the easiest way keeping all the existing data. - Data importing from and exporting to any dataset is supported. SQLMemTable provides you with the simplest way to import and export tables using ImportTable and ExportTable methods. - Internationalization / localization support. All text search and sorting functions use current system locale, so localizing your program with SQLMemTable is a very simple task. - Unicode support. All the text operations work with multi-byte encoding using ftWideString. - Comprehensive help. SQLMemTable comes with full documentation presented in SQLMemTable Developer's Guide and SQLMemTable Reference.

Added: 31-05-2004 | Version: v.2.12 | Downloads: n/a

Author:

AidAim Software AidAim Software [Homepage] [DSP files]

[ link: NexusDB105_Lite_Version_for_D7.Zip ] [ size n/a ]

[ Freeware ] [ No Source ]
[ D7 ]

NexusDB Client/Server Light database engine for C++Builder6

The Lite version is free for use in all types of projects, personal or commercial. It comes with packages and dcus, no source. Programs made with the Lite version of the database engine is limited to one simultaneous database, 5 tables, 10.000 recrords per table. Please find more info, downloads, and assistance on our web site and in our user community support newsgroups:

news://news.nexusdb.com/nexusdb.public.support

About the full version

NexusDB is the most flexible full source database engine for Delphi and C++Builder users. It scales seamlessly from databases kept solely in memory, via embedded server (single executable deployment) to full C/S solutions scaling to hundreds of users.

- Supports Delphi 5, 6, 7, and C++Builder 6

- NO royalty fees for server or client distribution.

- A large subset of SQL Ansi 92 is supported, including DDL.

- It adheres to the VCL TDataSet interface, so you can continue using all your favourite data-aware controls and report engines.

- In-memory table support which rivals pure memory-based database engines on speed on smaller datasets, while scaling very well to larger disk-based datasets (millions of records)

- In multi-user environments, only the server can access the data, minimizing risk of database corruption.

- Snapshot transactions provide 24/7 Live backup capability without disrupting regular database activity.

- Support for the IProvider interface (TClientDataSet) is included.

- The architecture is designed to be flexible, and can be enhanced by writing plugins, monitors and extenders.

- Free 3rdparty monitors/extenders already exist for custom client-server-client messaging (for instance, signal another client to update its view of data) and remote file handling on the server.

- It has lightning fast Winsock transports for networked C/S solutions; a Blowfish wrapper transport provides added security when needed.

- Conversion utilities for source and tables from other database engines (BDE, ADO, etc) are provided.

- Includes a Memory manager unit which replaces Borland's with a 24/7 usable one. Speeds up operations and keeps memory fragmentation away, vastly increased alloc/dealloc throughput on multi-cpu machines.

- Referential Integrity support available as conceptual monitor/extender example

- ODBC and dbExpress drivers available as separate drivers pack

- Support for RemObjects/Data Abstract

- Support for kbmMW

- Support for ReportBuilder DADE

- Support for FastReport

- .NET provider

- DeZign database designer by Datanamic now supports NexusDB

Additional binaries, trial versions based on the current release, manual and help files are available from the web site.

Added: 3-05-2004 | Version: 1.05 | Downloads: n/a

Author:

Nexus Database Systems Nexus Database Systems [Homepage] [DSP files]

Compatible files: [ D5 | D6 | C6 ]

[ link: pivotcubevcl.exe ] [ size n/a ]

[ Freeware ] [ No Source ]
[ D5 | D6 | D7 | C5 | C6 ]

PivotCube VCL is a set a visual components for OLAP analisys and reporting. You can use it to load data from huge relational databases, look for information or details and create summaries and reports that help the end user in making accurate decisions. It provides highly dynamic interface for interactive data analysis.

Added: 5-05-2003/7-03-2004 | Version: 7.01 | Downloads: n/a

Author:

Alex Zencovich PivotWare Lab [Homepage] [DSP files]

[ link: index.php?Page=DownloadExcelExport ] [ size n/a ]

[ Freeware ] [ With Source ]
[ D5 | D6 | D7 | D2 ]

The TscExcelExport component is an advanced, powerfull but easy component to export all records of a dataset from Delphi to MS Excel (97, 2000, XP or 2003). Many features are provided to change the layout, to add totals, to create groups, ...

Properties All kinds of settings to change the layout of the worksheet are provided.

Name of worksheet and file
Header texts
Begin row of header, titles (=fieldnames) and data (fieldvalues)
Width of columns or autofit
Font of header, titles, summary and data (Alignment, WrapText, Orientation)
Backgroundcolor and borders of header, titles, summary and data
Summaries for numeric or given fields (SUM, MIN, MAX, AVG)
Create groups with given fields
A lot of other options to customize the result

Events

To define the background color and font color, size, name and bold style of each cell
For exporting data without using a TDataset

Methods

Export to Excel
Save worksheet as XLS, HTM or CSV
Show print preview

Type library / COM

This component uses the Office server components from the Borland COM type library (Excel97 or Excel2000).
So MS Excel should be installed on the PC when using this component.

Demo application

A full demo application is supplied to view and test all features of the component.

If you like this component and/or you are using it in a commercial environment then you can register it. The registration cost is #30 or 30 US$. You can register yourself online on the website of Reg.Net (ID = 11696) : https://secure.reg.net/product.asp?I

Added: 9-08-2004/14-02-2005 | Version: 3.3 | Downloads: n/a

Author:

Stefan Cruysberghs Stefan Cruysberghs [Homepage] [DSP files]

[ kaado10.zip ] [ 1,636,326 bytes ]

[ Freeware ] [ No Source ]
[ D3 | D4 | D5 | D6 | D7 ]

KAAdo is a native Ado component for Delphi/CBuilder
KAAdo is about 90% compatible with KADao
Features:
1. Create, Repair, Compact, Encrypt Access'97 and Access'2000 MDB files
2. Create tables, add indexes, and fields to existing tables and so on.
3. Work as a Table an Query Component supporting both Queries and QueryDefs
4. Compatible with all data aware controls
5. Master/Detail support
6. Locate, Lookup support
7. Find_First, Find_Next, Find_Last, Find_Prior
8. Seek_Nearest, Seek_NearestEx
Optimised to work with MS Access and MS SQL Server

Added: 2-06-2003 | Version: 1.0 | Downloads: 1818/1818/18

Author:

Kiril Antonov Kiril Antonov - Hronos Ltd [Homepage] [DSP files]

[ kactrls10.zip ] [ 21,596 bytes ]

[ Freeware ] [ With Source ]
[ D6 | D7 ]

KA Controls contai two packages:
KA Floating Contols - some standard controls descendatns
with floating abilities and RollUp/RollDown support

KA FormImage Control
This control can be used to create a non-rectangular forms
with transparent areas.
Includes transparent editor like Adobe Gif export.
Added: 2-06-2003 | Version: 1.0 | Downloads: 1496/1496/9
Author: Kiril Antonov Kiril Antonov - Hronos Ltd [Homepage] [DSP files]

[ kadao91.zip ] [ 400,286 bytes ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | D6 | D7 | C3 | C4 | C5 | C6 ]

KADao is a native DAO component for Delphi.
It is the first freeware component to completly access all databases
supported by Microsoft DAO (Data Access Objects) including mdb,
xls, dbf etc..
BDE is not required. Microsoft(r) DAO(tm) must be Installed in order
component to run.
Support for both Microsoft(r) Access'xx-Access'97 and Microsoft(r)
Access'2000-2002.
Features:

1. Create, Repair, Compact, Encrypt Access'97 and Access'2000
MDB files

2. Create tables, add indexes, and fields to existing tables and so on.

3. Work as a Table and Query Component supporting both Queries
and QueryDefs

4. Compatible with all data aware controls

5. Master/Detail support

6. Locate, Lookup support

7. Find_First, Find_Next, Find_Last, Find_Prior

8. Seek_Nearest, Seek_NearestEx and many more ...

Added: 21-05-2000/9-01-2006 | Version: 9.1 | Downloads: 26861/21391/56

Author:

Kiril Antonov Kiril Antonov - Hronos Ltd [Homepage] [DSP files]

[ kadaocontrols80.zip ] [ 130,633 bytes ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | D6 | D7 | C3 | C4 | C5 | C6 ]

KADao Controls is a set of visual freeware controls for KADao
KADao Controls can be used only with KADao v 7.2 or higher
KADao Controls include:
KADaoDBGrid - Just link it to a KADAOTable and you get a profi app!,
KADaoSortByButton,
KADaoFilterByButton,
KADaoFindButton,
KADaoSeekButton,
KADaoSelectIndexButton,
KADaoCVFButton,
KADaoDateTime, KADaoDbGUIDEdit
KADaoExportButton, KADaoDBColumnCheckListBox,KADaoDBColumnListBox,
KADaoSearch,KADaoDBColumnCombo,KADaoDBStringList
KADao Controls gives the final user power to do
proffesional things with a single click

Added: 19-11-2001/2-06-2003 | Version: 8.0 | Downloads: 9823/9419/23

Author:

Kiril Antonov Kiril Antonov - Hronos Ltd [Homepage] [DSP files]