Linking DataViews in the ReportBuilder Data workspace (DADE), requires that the detail data be sorted by the linking fields. When DataViews are linked, DADE generates special linking SQL for the detail DataView. The linking SQL (Magic SQL) can be viewed by positioning the mouse over the DataView window and pressing Ctrl + Left Mouse button. Full Article…
Search the Wiki
Viewing 328 to 330 of 408 items
What is DADE?
What is DADE? DADE = Dade Access Development Environment. It is included with RB Professional and Enterprise. Visually DADE is represented by Report Designer’s Data workspace. Why use DADE? DADE enables developers and end-users to rapidly define the data access elements required by simple and complex reports. These elements typically included queries, master/detail linking relationships between Full Article…
Update Database Name
How to modify the DatabaseName stored with a DADE Query Currently when DADE is used to create dataviews, the DatabaseName is stored as part of the query definition. (This is consistent with Delphi’s approach to specifying a database connection for a Query object). In some cases, you may decide that the DatabaseName needs to be Full Article…