Description

Detailed DbiDoRestructure sample showing how to add fields and import existing data into an ftAutoInc key.

Informations

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

Platforms: D2

Description

This program demonstrates the BDE API function using.

Informations

• Status: Fully functional
• Source: Included
• Exe demo: included
• Size: 209kB

Platforms: D4, D5

Description

Sample application show how to use Dao Imported Library for open and save Access databases.

Informations

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

Platforms: D3, D4

Description

Simple unit to open database files.

Informations

• Status: Fully functional
• Source: Included
• Exe demo: included
• Size: 263kB

Platforms: D2, D3, D4

Description

Units for creating MS Excel or Lotus 1-2-3 files.

Informations

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

Platforms: CB1, CB3, D1, D2, D3, D4

Description

This file contains as info as author can find about connecting Delphi to MS Access tables, different troubleshooting, tips and so on. In Windows Help-file format.

Informations

• Status: Fully functional
• Source: None
• Size: 21kB

Platforms: D1, D2, D3

Description

A sample project that connects to Sybase and/or SQL Anywhere 5.5 and up (natively, without any components). None of the Open Client CT-Lib Component Pack components are needed (only the Sybase Open Client software). The sample is only a very basic project querying the database.

Informations

• Status: Fully functional
• Source: Included
• Exe demo: included
• Size: 162kB

Platforms: D3, D4, D5

Description

Sample about how to make permanent a query result set.

Informations

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

Platforms: D4

Description

Example of how to use the DAO Type-library. With this you can access & create MS-Access databases without the heavy BDE/ODBC stuff.

Informations

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

Platforms: D3

Description

Show you how to uses some of the Oracle Functions, Stored Procedures and standard Select Statements.

Informations

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

Platforms: D2

Description

Open source project. Contains:

• Graphic Query design sample (MS Access-like);
• LineDDA using Sample;
• Drawing something (lines, images etc.) over the MDI form's ClientHandle;
• Convert the query results to CSV (comma delimited) format;
• Convert the query results to XLS format;
• Convert the query results to RTF format;
• Drag and Drop sample between TCheckListBoxes (Tables).

Informations

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

Platforms: D5

Description

This example shows easy way to do a search on an incremental search in a field and show the search results on a DBGrid standard. In this instance has been used a TClientDataset, so that all data are loaded into memory (local). It should be borne in mind that this method can be costly if the table is very large data or data are not in local (server-side cursors, for example).

Informations

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

Platforms: D2005, D2007, D6, D7

Description

SimplePivot provides a method of displaying crosstab/pivot table data in 2 dimensions from a standard SQL grouping statement.

Given a statement such as...

• SELECT field1, field2, count(*) as field3 GROUP BY field1, field2

...field2 values are converted into column names in a resultant memory dataset. A more comprehensive readme is included in the zip. It should work with all versions of Delphi although I've only tested it with D7 and D2005.

There is a demo included which requires the BDE and JEDI components (the function doesn't require these however).

Informations

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

Platforms: D2005, D7

Description

Examples which shows how to implement multi-sort in TClientDataSet.

Informations

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

Platforms: D7