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
Yep, the second file belonged to
http://www.openoffice.org/issues/show_bug.cgi?id=105801
I deleted the first version and the second version from the
mediafire.com server, copied the view definitions into queries and that
is what the third version is about.
The main intention of that database was to demonstrate how to collect
spreadsheet data in a structured database table, query duplicates,
access duplicates for deletion, add time stamps and reprocess the
collected data for all kinds of reports:
- flat reports
- SRB reports created with the Sun Report Builder extension
- spreadsheet tables based on dynamic import ranges
- data pilots (aka pivot tables) in spreadsheets
- or even tables in impress.
Regarding this topic's initial issue, I think that the data pilot
provides everything to get an overview of weekly changing values and
names form properly structured data. The latter can only enforced by a
database. Copying multiple sheet tables side by side, across sheets or
even documents is certainly not the way to go.
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
