Tom -
We discussed this issue on the list in detail a while back and only
single table views are editable.
The note below was posted by Bill Downall on 7/17/2001.
Bernie
-----------------------------------
'I just did a test, and was able to edit and update a table through a
simple view of that table from the RBWin browser/editor.
In either the DOS or Windows version, it is very easy to make a view
"non-updatable." For example, if you "sort" a view, either by putting
an ORDER BY clause in the definition, or by sorting the browser
window, it is no longer updatable. This is part of the SQL definition of a
view.
Here are the SQL rules for a view being updatable, from "SQL Instant
Reference" by Martin Gruber, Sybex, ISBN 0-7821-4413-3:
"* It must be drawn on one and only one simply underlying table. In
other words, no joins.
*It must contain one and only one query, in other words, no usage of
UNION, EXCEPT, or INTERSECT
*If the simply underlying table is itself a view, that view also must be
updatable
*The SELECT clause of the contained query may only specify column
references, not value expressions or aggregate functions, and no
column may be referenced more than once
*The contained query may not specify GROUP BY or HAVING
*The contained query may not specify DISTINCT."
The books continues with this:
"These are fairly stringent restrictions, and some products may relax
them."
And from the same book:
"As with a base table, the rows of a view are by definition unordered.
Therefore, ORDER BY may not be specified." '
---------------------------------------
At 10:17 PM 8/26/2002 +1000, you wrote:
>G'day,
>
>Anyone managed to get a two table view to be an editable
>detail table in a tiered region in R:BASE for Windows 6.5++?
>
>Warmest regards,
>
>
>Tom Grimshaw
>coy: Just For You Software
>tel: 612 9552 3311
>fax: 612 9566 2164
>mobile: 0414 675 903
>
>post: PO Box 470 Glebe NSW 2037 Australia
>street: 3/66 Wentworth Park Rd Glebe NSW 2037
>
>email: [EMAIL PROTECTED]
>web: www.just4usoftware.com.au
>
>"... the control of impulse -- is the first principle of civilization."--
>Will Durant,
>Pulitzer Prize winning philosopher, writer and historian
>
>the most needed product in the world can be found at
>www.thewaytohappiness.org
>
>This email and any files transmitted with it are confidential to the
>intended recipient and may be privileged. If you have received this email
>inadvertently or you are not the intended recipient, you may not
>disseminate, distribute, copy or in any way rely on it. Further, you should
>notify the sender immediately and delete the email from your computer.
>Whilst we have taken precautions to alert us to the presence of computer
>viruses, we cannot guarantee that this email and any files transmitted with
>it are free from such viruses.
>
>================================================
>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/
