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:
You can also review the code without downloading the zip file by visiting the NexusDB Wiki: