×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On Mon, Aug 27, 2018 at 4:04 PM, Don Brown <DBrown@xxxxxxxxxx> wrote:
Hi Nathan,
Could you post a sample of a cascading views and why you consider this a
slick functionality ?
I think the best examples would be from SQL views that reference a database
that you're familiar with. In regard to nesting them, a base view might
begin with columns joined from related tables. A nested view is simply one
that selects from other views rather than from tables (physical files).
Over time, nests may grow to several layers deep.
We have a program helps query and maintain a "daily schedule" of bus
routes, activity runs (i.e. field trips), and miscellaneous jobs that
school buses and bus drivers may perform. The main SQL view used in that
program is actually drawn from about 30 nested sub-queries. By
externalizing the query processing, the program appears to be working with
just one file.
Externalizing the query processing simplifies the program logic. Under the
covers, database entities such as bus routes are being paired with school
calendar data that projects bus routes into the future. That data is paired
with vacations and other time off that bus drivers may have scheduled in
the future.
As an Amazon Associate we earn from qualifying purchases.