Re: [opensuse] openoffice java

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


The Tuesday 2007-09-18 at 09:42 +0100, G T Smith wrote:

Hum!

I tried via forms, but I couldn't get it right.

Used the wizard, and I do not remember it being easy or intuitive. It is
about year ago 1 set this up, and for the life of me I cannot remember
how I did it at the moment. Should have taken notes :-)

I need a manual for dummies... O:-)




<snip>

Your structure implies a read only join...


Huh? Rekall does it read write just fine.


In a strict one to many or many to many relationship an editable table
view does present a problem. When changing something on the many end of
a relationship one can be doing at least one of three things, making a
change which applies the edited record (i.e. correcting the spelling of
an authors name), introducing a new record (i.e. adding an author for
an existing book), or changing the record relationship (changing the
author of the book). A more usual approach would be to have a read only
table view with a select and edit option (it is also relatively easy to
program)...

I'm starting to see what you mean.


It shows like this:

Title Author
------------------ ---------
Robots and Empire Asimov ^
Rendezvous with Rama Clarke ^

The "Author" column fields are drop down lists from which I can choose an
author from any author in the authors table.


This is something definitely missing from the OpenOffice stuff, a drop
down list derived from a database table is useful to have as option .
With the above you can change author easily, but the other two edits do
present a couple of issues....

Yes and yes.


However a question remains.... how do you handle something like?...

Programming Perl, by Larry Wall, Tom Christiansen & Jon Orwant ...

:-)

Gotcha! Ie, "gotme". O:-)

I don't have a good solution. What I have is two more fields named "second
author" and "third author". The complex one would be another linked table:


index to book index to authors
---------------+-------------------
1 10
1 11
1 23
1 47

In this way, an indeterminate list of authors can be entered; but I don't
have an easy method of doing that, not being a database programmer.


In OpenOffice you can currently build (very) basic data entry forms, and
generate queries and reports for incorporation into OpenOffice documents

That's right, I use it for reports. For instance, to print a list of books
sorted by author so that I don't buy some book I already have ;-)

(not something I think you can do with ReKall).

It does generate reports, but not in the way I wanted. But I have to test
the current version, though, to see how it has improved. Rekall is
scriptable, too, but I haven't tried.

On the other hand I
would definitely not consider OpenOffice for your requirement.... The
two things have somewhat different focuses.

Pity.

I think of OOo as a replacement for M. Office, and this is a thing Access
could do quite easily. I don't like Access (I have been bitten by it), but
I can't deny the user and design interface are good, for me at least.

So I use rekall, which is pretty good, although it has its quirks too.


- --
Cheers,
Carlos E. R.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Made with pgp4pine 1.76

iD8DBQFG78IwtTMYHG2NR9URAu8+AJ0SVXAjyOfGcy2N8s5GtcgWr+KwUACfcZzr
C8FQxM8Zbmgh5ZVMZGIEUe8=
=gMPq
-----END PGP SIGNATURE-----

--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx

Relevant Pages

  • Re: Tuning Postgresql on FreeBSD 5.1
    ... It does 'selects' from several tables in database restricting results with ... where clauses and sorting with order by these reports contain lists of 40,000 ... Looking at one of the reports ...it's big select statement with lots of join ... However, the CPU load ...
    (freebsd-performance)
  • Reports based on several SharePoint lists
    ... I was assigned to a new project where I have to create few reports based on ... content stored in several SharePoint lists. ... create data connection for each of these lists and store ... Then use these connections by Excel ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Anti-Spam ideas for usenet/list harvested email addresses
    ... ORDB also accepts email reports rather than this, uh, ... who like to post to lists and usenet but have no control over how their ... Maybe I could even coordinate OpenPGP sub keys used to sign my ... I'll keep trying things and if I get some more mail server side wild ...
    (Debian-User)
  • Re: well done pearo
    ... another troll in the hope of goading me into another argument. ... Not trolls at all,its a valid point that you are a coward and need to run to ... So take your lists and your reports and stick them somewhere that you ...
    (uk.sport.football.clubs.celtic)
  • Re: locale and OpenOffice
    ... international standard formats for things like dates and measurements. ... Now I want OpenOffice to use the metric system (i.e. centimeters ... But I saw on a completely German Ubuntu OpenOffice ... lists for OpenOffice.org developers and a few lists for other languages than ...
    (Ubuntu)