× 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.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.