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…

Question “How can I create DADE QueryDataViews via code?” Solution The following example shows how to create a DADE datamodule that contains two query dataviews, customer/orders linked in a master/detail relationship. Download: CreateDataModCustOrderLinkedDataViews.zip Delphi code sample: procedure TForm1.CreateDataViews; var lDataModule: TdaDataModule; begin // create data module lDataModule := daGetDataModule(ppReport1); if lDataModule = nil then lDataModule  Full Article…

Question “How can I add search criteria that will be not be visible to my end-users?” Solution The following example shows how to use the DataView.OnBeforeGenerateSQL and OnAfterGenerateSQL events to and remove search criteria that cannot be seen by the end-user. Download:  DADEInvisibleSearchCriteria.zip Delphi code sample: procedure TForm1.Button1Click(Sender: TObject); begin PrepareReport(ppReport1); ppReport1.Print; end; procedure TForm1.PrepareReport(aReport:  Full Article…