The CGXDynamicRecordset class provides the functionality to dynamically specify SQL Statements at run time. Instead of creating a CRecordset-derived class with ClassWizard, you can create a CGXDynamicRecordset object and specify the SQL Statement by passing a string to the object.
CGXDynamicRecordset objects can be bound to a grid like any other CGXRecordset objects. CGXRecordWnd and CGXRecordView provide the necessary functionality to browse recordsets.
CGXDynamicRecordset also lets you loop through the records and change field values on the fly.
#include <gxodbc.h>