Description

SQL function to create easily sql string without take care if it's an update or insert SQL Statement. just add the value in a tstringList like fieldname=value and at the end contruct the SQL string.

Informations

• Status: Fully functional
• Source: Included
• Size: 51 703kB

Platforms: D2005, D2006, D2007, D2009, D2010, D7, DXE, DXE2, DXE3, DXE4, DXE64

Description

Background query. Includes parse query and bakground exec query - with new thread.

Informations

• Status: Fully functional
• Source: Included
• Size: 2kB

Platforms: D2, D3, D4, D5, D6

Description

TCOMP3Field: Component to decode/encode the COMPUTATIONAL-3 (COMP-3) field type used in Cobol tables.

• To decode: set digits, decimals, signed and call LoadFromByteArray or LoadFromStream. Access data decoded from AsDouble or AsString.
• To encode: set digits, decimals, signed and AsDouble. After that, call SaveToByteArray or SaveToStream to encode.

Tested on Delphi 7, but might work on other versions.

Informations

• Status: Fully functional
• Source: Included
• Size: 12kB

Platforms: D7

Description

The Database Comparer VCL (DBC VCL) compares and synchronizes databases structure (metadata) and table data for many popular databases. Currently supported databases: Oracle, MSSQL, MySQL, InterBase (FireBird, Yaffil), Sybase, Postgre SQL. This list is constantly updated and support for other databases will be added soon. Most popular database engines such as ADO and BDE are supported directly. Database specific libraries such as IBX, FIB, IBO, ZEOS, AnyDAC etc are supported as well. The library includes more than 25 components for Database development and its code is constantly being refined and improved. Features at a glance: - Can compare database with database, database with SQL/DDL script and SQL/DDL script with SQL/DDL script. - Can compare and synchronize data between two database tables. - Extracting the database metadata. - You can optionally select which objects (domains, tables, procedures, triggers etc.) should be compared. - Royalty free licensing. Free and unlimited email support. - Fully-indexed help documentation. Delphi, C++Builder and Visual Basic demo codes. The Database Comparer VCL library comes with full sources (demo versions does not have sources), detailed help and demo projects.

Informations

• Status: Fully functional
• Source: None
• price: $340
• Size: 1 560kB

Platforms: CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, D2007, D2009, D2010, D5, CB3, CB4, CB5, CB6, D2005, D4, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE7, DXE8

Description

DatasetBroker is free Delphi components that enable separation between data access and business logic easily. Please visit: http://www.delphi3000.com/article.asp?id=2414 for explanation about DatasetBroker.

Informations

• Status: Fully functional
• Source: On purchase/registration
• Size: 29kB

Platforms: D3, D4, D5

Description

The main purpose is that can change your table with out the knownlegde of how to do it. The program encapsulates all the SQL language for you. At the moment you can do the following: AddField, KillField from a table that you have created.

Informations

• Status: Fully functional
• Source: Included
• Size: 3kB

Platforms: D3

Description

Using these component you can give your user an easy way to filter query. Your user only giving some templates and the 'where clause' can be 'automatically' constructed. Ex: Input likes '1998;2002-2004' for field name YEAR will be constructed into '(YEAR = 1998) or (YEAR >= 2002 and YEAR <= 2004).

Informations

• Status: Fully functional
• Source: Included
• Size: 2kB

Platforms: D6, D7

Description

Library for conversion FoxPro to Delphi.

Realised functions: ALLTRIM, RTRIM, LTRIM, SPACE, FLEFT, FRIGHT, YEAR, DTOC, PADR, PADL, PADC, AT, LEN, STR, SUBSTR, TRIM, REPLICATE, EMPTY.

Informations

• Status: Fully functional
• Source: Included
• Size: 2kB

Platforms: D1, D2, D2005, D2006, D3, D4, D5, D6, D7

Description

IBGenerator is a very light component for fetching generator values from Interbase generators.

The classic way to fecth a generator value from a IB server is to define a stored procedure on the server and fetch the value by executing a IBStoredProc on the client.

This has 2 disadvantages:

• For every generator a stored procedure must be defined on the server.
• IBStoredproc needs a lot of resources on the client.

By using the IBGenerator component this is not longer the case. IBGenerator is very light and defining a stored procedure is not needed anymore.

Informations

• Status: Fully functional
• Source: Included
• Size: 4kB

Platforms: D5

Description

Microsoft OLE DB SDK 1.0 Header files for Borland Delphi 2.x. The OLE DB SDK is available for free download from Microsoft's site. For information about OLE DB, try Microsoft OLE DB Site and Microsoft Developer Network.

Informations

• Status: Fully functional
• Source: Included
• Size: 27kB

Platforms: D2

Description

SMSchema suite is the components for data modeling, flowchart and block/scheme engineering:

• TSchemaDesignArea - visual design pane to draw the model
• TSQLBuilderDialog - Visual Query Builder to construct the SQL-statement
• TSchemaCustomDataEngine, TSchemaBDEDataEngine - Custom engines for databases allow to use any data source (BDE, ADO, dbExpress, memory etc)

SMSchema is a native VCL engine with multi-language support.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $40
• Source price: $65
• Size: 206kB

Platforms: C2k10, D2010, C2k6, D2006, D7, CBXE3, DXE3, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8

Description

Through Snap Object Dataset components you will be able to join your business logic with the true rad powerfull delphi data aware controls; in this way your GUI will continue to completely being detached from the persistence layer.

The package contain two components TSnapVirtualDataset and TSnapObjectDataset and one editor for use of this components in a true RAD way. These components are completely free with source and demos, and with the editor you can create automatically for every properties of your business classes the associated TField descendent.

Informations

• Status: Fully functional
• Source: Included
• Size: 1 945kB

Platforms: D2005, D2006, D7

Description

With this component you can use inside of your application SQL-scripts like "stored procedures" in RDBMS Interbase, Oracle, when your RDBMS have not included DML (like dBase, FoxPro, SQLLite).

In this case you can do migration of your application very fast to other RDBMS.

Informations

• Status: Fully functional
• Source: On purchase/registration
• Source price: $10
• Size: 425kB

Platforms: D2005, D2006, D7

Description

Synopse mORMot is a Client-Server ORM and Service Oriented Architecture framework for Delphi.

It provides an Open Source self-sufficient set of units (even Delphi starter edition is enough) for creating any application, up to the most complex Domain-Driven design:

• Presentation layer featuring MVC UI generation with i18n and reporting for rich Delphi clients, or rich AJAX clients;
• Application layer implementing Service Oriented Architecture via interface-based services (like WCF) and Client-Server ORM - following a RESTful model using JSON over several communication protocols (including HTTP/1.1);
• Domain Model layer handling all the needed business logic in plain Delphi objects, including high-level managed types like dynamic arrays or records for Value Objects, or dedicated classes for entities or aggregates;
• Data persistence infrastructure layer with ORM persistence over Oracle, MS SQL, OleDB, with a powerful SQLite3 kernel (direct link to DB);
• Cross-Cutting infrastructure layers for handling data filtering and validation, security, caching, logging and testing (framework uses test-driven approach).

With mORMot, ORM is not used only for data persistence of objects (like in other implementations), but as part of a global n-Tier, Service Oriented Architecture (SOA), ready to implement Domain-Driven solutions.

Informations

• Status: Fully functional
• Source: Included
• Size: 2 545kB

Platforms: D2005, D2006, D2007, D2009, D2010, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6

Description

An audit-trail component. It logs database actions in a text-file, plus, shows a TOutline containing these actions.

Informations

• Status: Fully functional
• Source: Included
• Size: 11kB

Platforms: D1

Description

TDataFile enables applications to store database data from multiple tables in a single file. It saves, appends and loads multiple records from multiple tables and multiple databases in one file.

Informations

• Status: Fully functional
• Source: Included
• Size: 40kB

Platforms: D1, D2, D3

Description

Easy access to IB generators from Free IB components.

Informations

• Status: Fully functional
• Source: Included
• Size: 3kB

Platforms: D4, D5

Description

TDatabase descendent which monitors its child datasets and releases any pending edits idle for more than Timeout period (default to 1 minute).

Informations

• Status: Fully functional
• Source: Included
• Size: 4kB

Platforms: D1, D2, D3

Description

Works with DBXpress.

• TjlDbXScript - Execute multiple statements in file or TStrings.
• TjlDbxMetaData - Metadata for tables and Stored procedures.

Informations

• Status: Fully functional
• Source: Included
• Size: 9kB

Platforms: D6

Description

TmDataSetTableProducer is a TDataSetTableProducer with a pagecontrol-extension. Set the MaxRows property to the number of lines you want to show for each webpage, and the pagecontrol gives you the opportunity to choose the First-Previous-Next or Last page. Just one web-action needed. Uses the Get-method.

Informations

• Status: Fully functional
• Source: Included
• Size: 5kB

Platforms: D6

Description

TTransactable allows you to create ttransactable oriented components, also included is an object to group transactable components together under a larger transaction (which is itself transactable), allowing large trees of commit/rollback behavior if anything fails. Included is an ADO transactable object, allowing you to create multiple ADO connections to separate databases under one Native-Delphi controlled transaction.

Informations

• Status: Fully functional
• Source: Included
• Size: 9kB

Platforms: D3, D4, D5