Or you can make it a little fancier:

http://www.distortion.us/backv3.html?TBL=CN (Detail works, Edit/Delete
doesn't...and yeah, My Life With The Thrill Kill Kult is a real band...)

This is an example in my test environment that uses the SYSCOLUMNS
method I mentioned earlier. Everything you see is generated dynamically.
You can also see recursion occurring both in a 1->M (artists for this
concert) and 1->1 format (concert venue). That also occurs automatically
based on my file naming scheme and a query over SYSTABLES, and I control
which fields are displayed and which files are recursed from a sort-a
"control" table. So you can see it does give you a lot of control, and
queries within queries are no problem, although nobody is accusing SQL
of being too fast.

Later,
Z

> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, April 29, 2003 3:36 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: New Development Project - What to do it in?
> 
> 
> No compiler needed.
> 
> Here is a sample query stored in a source physical file.
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.



This thread ...


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

This mailing list archive is Copyright 1997-2026 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.