Larry and all,
The following is a quote from the "R:BASE 4.5 Plus!
Startup & New Features Guide. Chapter 9 R:BASE 4.5
Plus! General Enhancements"
"Updating Multi-Table Views. applicable when using
the browser (Info and Views menus), when using a form,
and with the UPDATE command.
New Feature
Before this update to R:BASE, only single table views
could be edited using the browser, a form, or the
UPDATE command. Now views constructed from multiple
tables can be edited. Data in a linking column or
from either side of a one-to-many relationship can be
edited. The result of the update can only be seen
when the data is refreshed by exiting the browser or
form and then re-entering.
If you are in multi-user mode, R:BASE may be set to a
frequency at which it refreshes the data in the form.
to check this setting; choose Settings from the Tools
Menu and then choose Autorefresh Interval from the
Multi-User menu, or type SHOW REFRESH at the R> prompt
and use SET REFRESH to specify the setting.
Changing a value in the linking column can cause rows
to disappear if they no longer match the view's
selection criteria. Non-updatable views occur when
inserting or deleting rows, and with view containing
SORT or GROUP BY clauses."
A cursory review of my BOOK CATALOG application shows
that under v6.5+ for DOS you can still use updateable
muti-table views. I just recently installed v7.1 for
DOS and V7.1 for Windows. I haven't tried out the
book catalog application under either v7.1 version.
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
--- Lawrence Lustig <[EMAIL PROTECTED]> wrote:
> > In DOS you could have a multi-table editable view
> as
> > long as you didn't use GROUP BY.
>
> I don't _think_ this is true, since it would be
> difficult in the case of 2:Many
> views to figure out which record on the 2 side to
> update, you have to deal with
> cases in which a column update changes the result
> set, and so on. MS Access
> allows this by introducing a non-standard SQL
> keyword DISTINCTROWS and the
> resulting views work differently than regular ones.
> But if you have a
> multi-table editable view defined, I'd love to see
> the definition.
>
> > Am I just a dinasor or are there others who lament
> the
> > loss of all those printed manuals we used to get
> with
> > our software purchases.
>
> Personally, I prefer electronic manuals which have
> the virtue of being
> searchable, and allow me to cut and paste sample
> code. Ocassionally I'll print
> out a chapter for off-line study. I really like the
> web based documentation
> (like the Property builder) which is both easy to
> use and guaranteed
> up-to-date.
> --
> Larry
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
