Question “How can I modify the SQL via code?” Solution Use the SQLBuilder class. See the DADE | SQLBuilder topic for a list of How To’s.

Question “How do I launch the Query Wizard outside the designer as a stand-alone dialog?” Solution The query Wizard can be launched separate from the designer and used to generate SQL as a stand-alone dialog. Start by creating a TdaQueryWizardDialog object and assigning it a SQL object to use. Once the dialog has been used  Full Article…

Question “How do I launch the Query Designer outside the designer as a stand-alone dialog?” Solution The query designer can be launched separate from the designer and used to generate SQL as a stand-alone dialog. Start by creating a TdaQueryDesignerForm object and assigning it a SQL object to use. Once the dialog has been used  Full Article…