Drew Jensen wrote:
Andreas Saeger wrote:
Andreas Saeger wrote:
Andreas Saeger wrote:
Download my database http://www.mediafire.com/?ydzh0thjzyy
Sorry I uploaded another version of that database collect2.odb
http://www.mediafire.com/?hdnnzivdnzi
Bah, how disgusting. The first was incomplete, the second belongs to a
bug report I filed today.
This is the third and only version of what I wanted to demonstrate:
http://www.mediafire.com/?mkmmnyytogy
<snip>
A dozend of people downloaded the wrong files.
My apologies for the inconvenience.
Hi Andreas,
Your emails and the issue you opened got me to think of this problem,
found in the first file, as a feature.
Currently a view in a database, using the Base GUI, is not editable.
However, as you pointed out - just open the view in edit mode and run
it, if the query that makes up the view can produce an updateable result
set then it is editable. On that point, what queries can be updated
there has been steady improvement in Base.
OK so you can't base an editable Form on a view, but in reality that
just means you need to have a query with the same SQL statement for use
in the Form. LOL, and of course that can be thought of as a 100%
increase in the number of entities you need to have....still; the tools
do let you make one from the other, quite easily. (Squeezing lemons and
looking for sugar - huh?)
It would be nice if the Base GUI tools could work with updateabe views
where and when it could.
Drew
Another GUI-related request for enhancement related to this topic:
http://www.openoffice.org/issues/show_bug.cgi?id=105691
Improve the drag&drop interface so we can drag spreadsheet ranges and
drop them directly onto tables or even queries with the right order of
columns.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
