Chris Lupton

Send e-mail to this Author

  • unlimited number of local/remote databases for backup
  • unlimited number of Windows/Linux servers (FB 2.1, 2.5 and 3.0 are supported)
  • option for managing multiple backups for one database
  • optional ZIP compression and FTP transfer of backups
  • running as an application or as a service
  • lifetime license only USD 40
Author Products

Total 1 product

SimplePivot v.1

Code Samples > Samples > Database

By Chris Lupton.

Freeware + source 12 Mar 2006

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