>>The fact that RBDos is still needed says a lot - there can't be many, if
>>any, people running it on a true dos system, can there?
There are a few holdouts. Mostly non-profit organizations. No need to
change as they can't afford to pay someone to change what ain't broke.
If your needs don't change, the old versions of RBase hold up just fine.
And remember, those DOS machines boot up in seconds, not minutes. There is
something to say for that too, LOL.
--Dennis McGrath
----- Original Message -----
From: "Tom Grimshaw" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 9:51 PM
Subject: Re: Views and Layout
G'day Alastair and Javier,
What I am about to suggest is not what you asked for but may
open up some doors for you.
What I wanted was a way to give users almost point and click
simplicity of use with the power of the in-built R:BASE WHERE
builder across multiple tables.
For novice SQLers the in-built R:BASE WHERE builder has the
disadvantages of:
1. needing to know how to properly construct SQL syntax,
2. having no on-screen definition of what the symbols mean,
3. having no samples available of how to correctly enter data,
4. needing to know the table structure and how to code
sub-selects in order to do a cross table query.
I already had extensive CHOOSE options so users could do the
more common cross table queries but not "Give me all the people
coded as top prospects in one state who have purchased a widget
in the last x months". That requires a query across Persons,
Addresses, TranHeader, TranDetail and ProductsServices. Most
of my users wouldn't even know that let alone how to create
such a query.
So I called my simple CHOOSE menus a "Simple Sifter" and built
what I call a "Super Sifter". This allows a user to:
1. select a table (persons or organisations,
2. select the first column on which to sift the data,
3. and enter the selection parameters (on a screen similar to
the WHERE builder but with explanations and sample data and
buttons to go to further help)
4. select the operator,
5. select whether to proceed from there to another linked table
and repeat steps 2 to 5.
At each pass it displays the SQL command it is progressively
building. It correctly builds sub-selects based on the table
relationships and as well as being a query builder is also
effectively an SQL tutor.
Once finished the user has the ability to save the result and
name the query for later retrieval and use.
'Cos I didn't figure out how to do it dynamically I built 3
forms. The table relationships and SQL display screen is
custom to BizMan but the WHERE builder type screen, and the
record selection options are generic.
If you want more mass on the theory above then download the
BizMan demo from our web site and plagiarize what you will.
From the Main Menu go to:
[Contact Manager\Persons\Browse those where...]
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
