SQL > Using Local SQL VIEW-files

Disk-stored SQL VIEWs used for intermediate results

As the BDE implementation of Local SQL is lacking a way of in-memory storage of temporary data and limited options of SQL nesting, in some cases the solution may be to utilize SQL VIEWs stored locally as disk files (*.sql) to be used as sources for some final SQL query.
If you repeatedly are doing the same crosstab* request on dynamic data, solving the crosstab challenge may be to use a number of intermediate queries, not as results but as SQL queries dynamically retrieving data and corresponding the use of SQL VIEWs.

Example of crosstab with Paradox/PdxEditor

http://nknabe.dk/database/sql/code/SQL_crosstab_Paradox.htm

*: some times also named Pivot tables