Delphi 5.0x freeware [Data Base Programming]

Delphi 5.0x freeware
Data Base Programming

[ 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_D5.Zip ] [ size n/a ]

[ Freeware ] [ No Source ]
[ D5 ]

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: [ D6 | D7 | 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/21-03-2006 | Version: 7.2.6.5 | Downloads: n/a

Author:

Alex Zencovich Alex Zencovich [Homepage] [DSP files]

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

[ Freeware ] [ With Source ]
[ D1 | D2 | D3 | D4 | D5 ]

Checks and repairs Paradox tables. Features: fixes "VAL file out of date" and "corrupted autoincrement generator" errors, "pack tables" option, header borrow, orphans detection/removal. Handles tables protected with master password.

Added: 4-10-1998/25-09-2000 | Version: 4.20 | Downloads: n/a

Author:

Roman Krejci [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]

[ link: ] [ size n/a ]

[ Freeware ] [ With Source ]
[ D5 ]

The WPI Components Package (MIDAS alternative)

TWPIDataSocket Provides your client application connectivity to the WPI Server. User authentication, client versioning and more.
TWPIClientDS A 100% compatible dataset that serves as just more than a table. Use this component as a query or table, filters can be executed on the server and again once the data is returned to the client without having to do any request extra from the WPIFileServer. Extended search capabilities, brief case tables for offline use, ability to fetch blobs upon demand, cached updates and more.
TWPIShell Set the URL or Email address and fire up the users default web browser or email client all with one command. Also works with standard windows applications with registered extensions.
TWPIFileDlg Provides transparent file and directory access to your server as if you were on your own machine. Just set a few properties and it's all there. Upload, Download, Rename, Delete and much more. No coding necessary.
WPIFileServer The backbone of the entire package. A Multithreaded TCP/IP server that serves up the data, manages files, users, messaging, individual user logging, client versioning and more. Current databases supported are Interbase, Informix, Oracle, MS SQL Server, Foxpro, Sybase, Access, Paradox, DBase, DBISAM, ODBC.

Due to the huge success of WPI Components release 2.0 has been started and is currently in development. The release will include a revised WPIClientDS, better client authentication and a lot more functionality.
Delphi 5 Professional or Enterprise Edition Required(!)

Added: 26-06-2000/25-06-2000 | Version: 1.0 13/6/2000 | Downloads: n/a

Author:

Chris Weston Web Poppers Internet [Homepage] [DSP files]

[ humantl.zip ] [ 7,370 bytes ]	[ Freeware ] [ With Source ] [ D2 \| D3 \| D4 \| D5 ]
Table Lock is a TTable descendent component (mostly in Spanish) Added: 16-04-2000 \| Version: 1.2 \| Downloads: 2624/2624/0

[ ibbrow10.zip ] [ 13,478 bytes ]

[ Freeware ] [ With Source ]
[ D5 ]

Interbase browser application using Interbase Express. Features: sorting using indexis, searching, finding, counting, filling.

Added: 6-04-2001 | Version: 1.0 | Downloads: 1638/1638/1

Author:

Tomas Mandys-MandySoft [Homepage] [DSP files]

[ is2sql.zip ] [ 637,741 bytes ]

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

Provides an easy way to build web- based application. Creates dynamic web pages interacts with databases - now directly to Interbase or via BDE in manner of Allaire's Cold Fusion.

Added: 15-10-2001 | Version: 1.11 | Downloads: 2954/2954/2

Author:

Andrei Ivanov [Homepage] [DSP files]

[ JC_QTools.zip ] [ 573,448 bytes ]

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

Jayan's Query Tools Components

TQueryByFilter
TQueryBySQL

To use above components you have to install TKbmMemTable by Kim Bo Madsen (ver 2.50 included).

Added: 1-10-2000 | Version: 1.0 | Downloads: 2007/2007/1

Author:

Jayan Chandrasekhar [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]

[ 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]

[ kadaope.zip ] [ 258,682 bytes ]

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

KADao Personal Edition (PE) is a native DAO component for users of Delphi 5 and 6 Personal editions
It is created in a way that without TDataset to accces all databases supported by MS DAO
KADaoPE is a set of components to use with Microsoft(r) DAO(tm) Engine
KADaoPE is FREE for commercial and non-commercial use i.e it is absolutely free!
KADaoPE is intended to be used with direct COM access to DAO
KADaoPE comes with no support of any kind.
Use MS DAO Help files for work with KADAO PE

Added: 9-09-2001 | Version: 5.70 | Downloads: 3929/3929/3

Author:

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

[ kbmmemtb.zip ] [ 117,348 bytes ]

[ Freeware ] [ With Source ]
[ D3 | D4 | D5 | C3 | C4 ]

TkbmMemTable is a 100% TDataset compatible in memory full featured table which is not dependant on the BDE at runtime. Features include: - 100% TDataset compatible - 100% compiled into the exe. - 100% independant of the BDE during runtime. - Blob compression - Full filter support not only through OnFilterRecord but also using an expression in the Filter property. - Several easy interfaces to the outher world (load/save data/structure to/from other tables or files) - Multilevel transaction control (undo insert/delete/updates since transaction start) using StartTransaction, Commit and Rollback. - Versioning and journaling for saving deltas of what has happened to the table in another table or file - Build in 100% extendable resolving capabilities of deltas and alot more. - Contains middleware capabilities through the resolver and deltas. Price for using as middleware?.... $0 - Contains designtime editor for designing the table. - 100% Thread safe. - Allows multiple cursors to same physical data. - Automatic persistency. Load from a file on opening and save to it on destruction/close. - Form persistency. Store default data at the form at designtime. - Extract or set the data as a commatext. - Snapshots. Save the complete table in a variant and load the table from a variant. - On the fly sorting on any fields ascending/descending. - Add data to the record without having a field using the record tag property. - Supports 99% of all fields supported by TTable/TQuery. - Lookup, Locate, FindNearest, SetKey, GotoKey, FindKey, EndKey, Ranges supported. - Bookmarks supported. - Unlimited number of real indexes supported. - Ressource strings translated to >10 languages. - Field types supported: ftString,ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency, ftDate,ftTime,ftDateTime,ftAutoInc,ftBCD,ftBlob,ftMemo,ftGraphic,ftF mtMe mo, ftParadoxOle,ftDBaseOle,ftTypedBinary,ftBytes, ftVarBytes, ftFixedChar,ftWideString,ftLargeInt,ftADT,ftArray - Full Master/Detail support both as master and as detail table. - Many more internal routines available to the programmer by choise. - Extendable. Full source code included. 100% free. Infoware... let me know when you are using it! Middleware components/tools developed using TkbmMemTable must be released as Open Source and freeware. Find latest versions at http://www.onelist.com/community/memtable [more]

Added: 25-01-1999/26-03-2000 | Version: 2.33 | Downloads: 19608/10892/14

Author:

Kim Madsen [Homepage] [DSP files]

[ kbmmemtb252ibeta.zip ] [ 174,156 bytes ]

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

Latest version of the open source/free(info)-ware in memory table component TkbmMemTable. Although the beta label its very stable. Includes massive amounts of improvements and new features. Please join the memtable community at http://www.onelist.com/community/memtable for support and for getting information about new releases. Also download the file and documentation (and dont forget kbmX10 (X10 house control) and kbmWABD (Rapid Web development tool)) from http://delphi.e-indexit.com

Added: 13-05-2001 | Version: 2.52i Beta | Downloads: 2452/2452/1

Author:

Kim Bo Madsen [DSP files]

[ kdbexp.zip ] [ 11,857 bytes ]

[ Freeware ] [ With Source ]
[ D2 | D3 | D4 | D5 | C1 | C3 | C4 ]

Database Export pack contains several components for exporting database data to other formats. TKDatasetToText - export data from an active dataset into text file; TKDatabaseToText - export and import whole database to the text files. Memo and BLOB fields are also supported; TKDatasetToHTML - save an active dataset as HTML file; TKDatasetToDBF - save an active dataset into DBase table; TKDatasetToPrint - print dataset;

Added: 16-04-2000 | Version: 1.0 | Downloads: 7504/7504/5

Author:

Sergiy Korzh Korzh.com [Homepage] [DSP files]

[ MFDBEditMask_20.zip ] [ 4,391 bytes ]

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

This little free component enhances the default behaviour of the TDBEdit component available with Delphi. It publishes two fields of TCustomMaskEdit and allows the component to automatically set the correct mask for the linked DataField. Owing to this, you will be able to introduce masks without having to work with TField properties. Present version corrects a bug in the previous ".dcu" that did not work correctly. usual and the new property EditMask. That's all.

Added: 18-04-2003/24-11-2003 | Version: 2.0 | Downloads: 665/659/4

Author:

Marco Frosolini [DSP files]