Previous 20 filesDelphi 6.0x freeware
Data Base Programming

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

  1. ZCore - Core classes and interfaces. Contains Java style objects and collections as well as compatibility types and functions.
  2. ZParseSql - SQL specific for syntax and lexical analysis.
  3. ZPlain - Native plain API to supported SQL servers.
  4. 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.
  5. ZComponent - visual components descended from TDataset.

Installed components:

  1. TZConnection: This component encapsulates the database connection and transaction management.
  2. TZReadOnlyQuery: TDataset component to execute SQL queries and process data in read-only mode.
  3. TZQuery: TDataset component which allows data modifications in regular and cached mode.
  4. TZUpdateSQL: Analog of standard TUpdateSQL component to explicite definition of Insert/Update/Delete SQL statements for TDataset modifications.
  5. TZStoredProc: The component to execute SQL stored procedures.
  6. TZSQLProcessor: The component to execute SQL scripts for different SQL and various delimiter types.
  7. TZSQLMonitor: The component to monitor all outgoing SQL queries and other logging information.
  8. 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_D6.Zip ] [ size n/a ] [ Freeware ] [ No Source ]
[ D6 ]
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 | 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: 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]

    [ IndexTab.zip ] [ 22,061 bytes ] [ Freeware ] [ With Source ]
    [ D6 ]
    An IndexTab component facilitates browsing through a dataset whose primary index is, or begins with, a stringfield. An IndexTab appears on a form as a column of buttons; when the (say) 'M' button is pushed, then the dataset's status is changed so that the first record whose key begins with 'M' becomes the current record. After that, the 'in' button changes the buttons to 'Ma', 'Mb', and so on, except that no button is ever generated if there is no corresponding record in the dataset. The 'out' button does what you think it does. If the component is too small, buttons are generated selectively.
    Archive includes demo application using Employee.DB from DBDEMOS database.
    Added: 10-12-2001   |  Version: 20011209   |  Downloads: 2222/2222/1
    Author:Robert R. Fenichel   [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]

    [ jadbfgrid.zip ] [ 541,092 bytes ] [ Freeware ] [ No Source ]
    [ D6 ]
    With this component you can access and view a Foxpro, dBase table in a grid environment. You can execute all functions which are available on a dbf table. Grid control is designed to display multicolor columns. Also you can save memo text and graphic files (bmp and jpg) in memo fields.
    Added: 26-12-2001   |  Version: 1.1   |  Downloads: 1465/1465/1
    Author:Adrian Jescu   [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]

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

    [ KADL10.zip ] [ 5,033 bytes ] [ Freeware ] [ With Source ]
    [ D6 | D7 ]
    KADriveLetter gives ability to mantain assigned drive letters
    to devices in your system
    It can hadle 3 manipulations
    1. Assign drive letter to Device/Partition
    2. Remove drive letter assigned to Device/Partition
    3. Change drive letter assigned to Device/Partition
    Added: 4-10-2004   |  Version: 1.0   |  Downloads: 560/560/5
    Author:Kiril Antonov   Kiril Antonov - Hronos Ltd   [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]

    [ MSDBCheckListBox.zip ] [ 3,144 bytes ] [ Freeware ] [ With Source ]
    [ D4 | D5 | D6 ]
    A CheckListBox with a CheckBox for each Bit in a Integer or for each Char in a String. (FreeWare with Source) for D4 D5 D6 D7 Component TMSDBCheckListBox: Class(TCheckListBox) New Prppertys: DataSource: TDataSource DataField: TDataField CharCkecked: Char CharUnChecked: Char CharGrayed: Char Use: Integer: You can use this Component with Integer and String DataFields. If You use IntergerField then the Item-Index is the BitIndex for the CheckBoxes. You cannot use AllowGraed. String: If You use StringField then the Items-Index is the CharPosition, and the String Contains Chars of the propertys CharCkecked, CharUnChecked, CharGrayed. You can use AllowGrayed,
    Added: 6-07-2004   |  Version: 1.0   |  Downloads: 645/645/2
    Author:ibego2003   [DSP files]

    [ mysql_udf_example.zip ] [ 2,190 bytes ] [ Freeware ] [ With Source ]
    [ D5 | D6 | D7 ]
    About month ago I spend two hours seeking for an example in web how to create UDF module for MySQL. Finally I'm deciding to look in MySQL manual. This is result of my efforts. So this example intended for lazy (like me) people.
    Added: 27-01-2003   |  Version: n/a   |  Downloads: 2660/2660/11
    Author:V.Cechanowski   [DSP files]

    [ Paradox.zip ] [ 14,123 bytes ] [ Freeware ] [ With Source ]
    [ D3 | D4 | D5 | D6 ]
    The TParadox component allows you to read a Paradox 4+ table without using the BDE. It's short (adds no more than 11K to the program, less if you're already using File I/O), fast (faster then TTable + BDE), and simple (needs only the Paradox.pas file). Reads all Paradox field types except BCD fields. Cannot insert or delete rows. TParadox.FindKey can find a record using the Primary Index, but it can't use any secondary indexes. Written in Delphi 4, but should be compatible with Delphi 3, 5 and 6. Support for Blob (memo) fields and update (in-place) of alpha fields. Sample application and table included. Read comments in the .pas file for more info.
    Added: 11-09-2002/18-08-2003   |  Version: 1.3   |  Downloads: 2414/2413/14
    Author:Howard Flank   [DSP files]

    [ PDJ_DBCheck.zip ] [ 18,085 bytes ] [ Freeware ] [ With Source ]
    [ D3 | D4 | D5 | D6 ]
    DBCheckBox which allows to use:
    a.. ImageType: 7 different glyph
    b.. Style: bvNone, bvLowered, bvRaised, bvRound, bvSimple
    c.. ColorFont: ColorFontIn, ColorFontOut
    d.. PlayMusic: Play music on event Checked / not Checked
    e.. MultiLine Hint: When mouse in position
    f.. Flat
    g.. Transparent
    Added: 9-09-2001/25-02-2002   |  Version: 1.50   |  Downloads: 3499/3494/5
    Author:Peric DJordje   PDJTools   [Homepage]   [DSP files]

    [ RRF_IndexTab.zip ] [ 26,791 bytes ] [ Freeware ] [ With Source ]
    [ D6 ]
    IndexTab is a component to facilitate browsing through a dataset by jumping to records selected by the value of an IntegerField, SmallIntField, or StringField. An IndexTab appears on a form as a column of buttons whose captions are prefixes (for stringfields) or values (for integerfields) of the field of the dataset. Pressing the button makes the first matching record become the current record. Special 'in' and 'out' buttons regenerate the other buttons to provide a narrower or broader selection of values from the dataset.
    Archive includes demo application that uses the Employee.DB dataset from DBDEMOS.
    Added: 26-12-2001   |  Version: 20011225   |  Downloads: 1499/1499/2
    Author:Robert R. Fenichel   [Homepage]   [DSP files]

    1995-2006 Robert M. Czerwinski ( The Delphi Super Page a.k.a. DSP ).
    All rights reserved.
    Next 20 files