NexusDB

A complete example that shows how to use Delphi to dynamically build SQL statements and to select rows of data that are six months old. It was written in response to a request from the newsgroups.

The code uses an embedded server and executes DDL code to create the sample table. It also pre-populates the table with sample data and has code to refresh the data with current dates to ensure the application will work no matter the actual date.

A review of the newsgroup thread:
http://www.nexusdb.com/forums/showthread.php?t=14226

You can also review the code without downloading the zip file by visiting the NexusDB Wiki:
http://www.nexusdb.com/wiki/index.php?title=SQL_Example_DateTime_Range#D...