Tech Tip…Select Interbase Current Date Question: “Using Interbase, how I can select the current date?” Answer: Select<br>&nbsp;&nbsp; Cast(‘Now’ as Date) Today

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…