[opensuse] openoffice java
Hi 2.0.4 openoffice from SuSE doesn't let me save database forms created with the wizard. I downloaded 2.2.1 and it does let me save forms but only via the inbuilt database. I can't connect to MySQL databases as before as choosing Tool>Options>Java crashes openoffice and so I can't choose a jre or jdbc class. I've also tried the 64 bit openoffice and the openoffice with jre download but none of them work 100%. Sempron with 64bit 10.2 Can anyone help? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-09-16 at 00:42 +0200, primm wrote:
Hi 2.0.4 openoffice from SuSE doesn't let me save database forms created with the wizard. I downloaded 2.2.1 and it does let me save forms but only via the inbuilt database. I can't connect to MySQL databases as before as choosing Tool>Options>Java crashes openoffice and so I can't choose a jre or jdbc class.
I'm using OpenOffice_org-2.2.1-43.1 in opensuse 10.2 and I can. But I had to play with the java versions. From memory, I think I'm using the one from Sun (via suse's rpms, version 1.5.0_12), and I had to install the mysql-connector-java-3.1.12-35 rpm. I can connect to my MySQL databases, but I haven't tried forms. HTH. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7G08tTMYHG2NR9URAg1MAJ9OLbdcAUIbUSKWPupVgZheGo7rZwCeOmlm AM9VaYI0ZKpsidHR/wD0m4c= =LRkX -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 16 September 2007 01:39, Carlos E. R. wrote:
The Sunday 2007-09-16 at 00:42 +0200, primm wrote:
Hi 2.0.4 openoffice from SuSE doesn't let me save database forms created with the wizard. I downloaded 2.2.1 and it does let me save forms but only via the inbuilt database. I can't connect to MySQL databases as before as choosing Tool>Options>Java crashes openoffice and so I can't choose a jre or jdbc class.
I'm using OpenOffice_org-2.2.1-43.1 in opensuse 10.2 and I can. But I had to play with the java versions. From memory, I think I'm using the one from Sun (via suse's rpms, version 1.5.0_12), and I had to install the mysql-connector-java-3.1.12-35 rpm. I can connect to my MySQL databases, but I haven't tried forms.
HTH.
-- Cheers, Carlos E. R.
Yeah. That's true. Some work and some don't. The one supplied with ooo doesn't. 1.4.2 works but not is 1.5.0 is also installed. that was my problem. I had both the sun versions installed. Delete either one of them and it's fine. Steve. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-09-16 at 11:03 +0200, primm wrote:
Yeah. That's true. Some work and some don't. The one supplied with ooo doesn't. 1.4.2 works but not is 1.5.0 is also installed. that was my problem. I had both the sun versions installed. Delete either one of them and it's fine.
No, you do not need to delete any version of java. I have three currently. Simply go in OOo to the tools menu, options, java, wait perhaps a minute till it detects the existing java engines, then choose one. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7QGKtTMYHG2NR9URAhA/AJ9vAPaPVyDn51ntgzvhAdJjkpKEOwCeOTP0 ITBQEPL5NzmXE0TkqC/xRUw= =9HLn -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 16 September 2007 12:12, Carlos E. R. wrote:
The Sunday 2007-09-16 at 11:03 +0200, primm wrote:
Yeah. That's true. Some work and some don't. The one supplied with ooo doesn't. 1.4.2 works but not is 1.5.0 is also installed. that was my problem. I had both the sun versions installed. Delete either one of them and it's fine.
No, you do not need to delete any version of java. I have three currently.
Simply go in OOo to the tools menu, options, java, wait perhaps a minute till it detects the existing java engines, then choose one.
-- Cheers, Carlos E. R.
Hi Carlos. No. That's exactly what was causing the problem for me. The different versions did not appear. I had 1.4.2 AND 1.5.0 installed. Crash. Lose 1.5.0 and 1.4.2 appeared. Lose 1.5.0 and 1.4.2 appeared. At work with 2.0.4 all versions show but the form wizard doesn't allow saving. This has never been fixed in the SuSE release as far as I can tell. That's why I went with 2.2.1 from the ooo site and just the 1.4.2 so that everything in the database module just worked. It wasted a day's work. I hope that this information will help to save others time. Un saludo, Lynn -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Sunday 2007-09-16 at 00:42 +0200, primm wrote:
Hi 2.0.4 openoffice from SuSE doesn't let me save database forms created with the wizard. I downloaded 2.2.1 and it does let me save forms but only via the inbuilt database. I can't connect to MySQL databases as before as choosing Tool>Options>Java crashes openoffice and so I can't choose a jre or jdbc class.
I'm using OpenOffice_org-2.2.1-43.1 in opensuse 10.2 and I can. But I had to play with the java versions. From memory, I think I'm using the one from Sun (via suse's rpms, version 1.5.0_12), and I had to install the mysql-connector-java-3.1.12-35 rpm. I can connect to my MySQL databases, but I haven't tried forms.
HTH.
The latest version of mysql-connector was 5.x.x last time I looked and I have at least one thing running (funambol) that requires this version or better of the connector, (BTW the connector is from the MySQL people). The standard SuSE RPM distribution is still 3.x.x is therefore a bit problematic in this area as you tend to need to deploy both versions if you require the latest version for anything. I have not tested out 5.x.x with OpenOffice. (It would be interesting to find out if anyone had, as it would simplify things just to have the one version). - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG7PQPasN0sSnLmgIRAqqxAKC+RWxUqPuRaAfrCfAHlgQyT72M2QCgpVt9 g7j/bpKmOI5BVDfiAlGjDsE= =TIc3 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-09-16 at 10:14 +0100, G T Smith wrote:
mysql-connector-java-3.1.12-35 rpm. I can connect to my MySQL databases, but I haven't tried forms.
The latest version of mysql-connector was 5.x.x last time I looked and I have at least one thing running (funambol) that requires this version or better of the connector, (BTW the connector is from the MySQL people).
The standard SuSE RPM distribution is still 3.x.x is therefore a bit problematic in this area as you tend to need to deploy both versions if you require the latest version for anything. I have not tested out 5.x.x with OpenOffice. (It would be interesting to find out if anyone had, as it would simplify things just to have the one version).
I haven't been able to do much with OOo base. I have a database for my library, and the "books" table is linked to the "author" table. Well, OOo shows the numbers refering to the authors, not the names. I can correct this in "views", but they are read only. So, I use rekall to manage my database. I miss a reference or manual for dummies for OOo base. Maybe there is way, but I can't find it by trial and error. Rekall was much, much, much easier. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7QMHtTMYHG2NR9URAhd0AJ9NO1MdKh2vdHQ9X12wltR3iUiI2wCfUJ7q e7fwhCDrRach3es2pF5akg8= =kXJw -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Sunday 2007-09-16 at 10:14 +0100, G T Smith wrote:
it would simplify things just to have the one version).
I haven't been able to do much with OOo base.
I have a database for my library, and the "books" table is linked to the "author" table. Well, OOo shows the numbers refering to the authors, not the names. I can correct this in "views", but they are read only.
So, I use rekall to manage my database.
I miss a reference or manual for dummies for OOo base. Maybe there is way, but I can't find it by trial and error. Rekall was much, much, much easier.
I have used it to to tie into the OTRS database (as a mailmerge option). The database forms stuff is usable to some extent... but there are moments when it rather feels like pulling ones own teeth out without anaesthetic :-)... - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG7QwmasN0sSnLmgIRAnBNAKCnQjOGFWU5RM41ELmW2R1gbO9q3wCgjACK maFr7ElXWc2gAw6diS82SW4= =Swia -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-09-16 at 13:29 +0200, Hylton Conacher (ZR1HPC) wrote:
<snip>
Can I suggest one of you submit a bug report? How about it Carlos?
But I don't see a bug... it's designed that way. What I need is documentation. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7SvdtTMYHG2NR9URAhJ0AJ95xjCzmMHn2b3EeIMK4iC5yzKb9wCfWbB6 Bw3GpGAFUXk/wbWPAf4Q45Q= =GlMk -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Carlos E. R. wrote:
The Sunday 2007-09-16 at 13:29 +0200, Hylton Conacher (ZR1HPC) wrote:
<snip>
Can I suggest one of you submit a bug report? How about it Carlos?
But I don't see a bug... it's designed that way.
What I need is documentation.
... And therefore the bug is lack of documentation :) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
I miss a reference or manual for dummies for OOo base. Maybe there is way, but I can't find it by trial and error. Rekall was much, much, much easier.
I have used it to to tie into the OTRS database (as a mailmerge option). The database forms stuff is usable to some extent... but there are moments when it rather feels like pulling ones own teeth out without anaesthetic :-)...
Like me all day yesterday. When you leave the dentist's chair having had it filled instead of pulled it really is worth it. Lynn x -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 16 September 2007 12:18, Carlos E. R. wrote:
The Sunday 2007-09-16 at 10:14 +0100, G T Smith wrote:
mysql-connector-java-3.1.12-35 rpm. I can connect to my MySQL databases, but I haven't tried forms.
The latest version of mysql-connector was 5.x.x last time I looked and I have at least one thing running (funambol) that requires this version or better of the connector, (BTW the connector is from the MySQL people).
The standard SuSE RPM distribution is still 3.x.x is therefore a bit problematic in this area as you tend to need to deploy both versions if you require the latest version for anything. I have not tested out 5.x.x with OpenOffice. (It would be interesting to find out if anyone had, as it would simplify things just to have the one version).
I haven't been able to do much with OOo base.
I have a database for my library, and the "books" table is linked to the "author" table. Well, OOo shows the numbers refering to the authors, not the names. I can correct this in "views", but they are read only.
So, I use rekall to manage my database.
I miss a reference or manual for dummies for OOo base. Maybe there is way, but I can't find it by trial and error. Rekall was much, much, much easier.
-- Cheers, Carlos E. R.
The frontend to MySQL is just wonderful. Have to have it. The report creation is almost there too. Dragging to create relationships is better than Access Can't swap now. . . Lynn x -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-09-16 at 19:16 +0200, primm wrote:
The frontend to MySQL is just wonderful. Have to have it. The report creation is almost there too. Dragging to create relationships is better than Access Can't swap now. . .
Rekall or OOo base? Because in OOo I can't use tables with relations in read/write mode, only read. I can create a "View" like this from two tables: Books Authors ------- --------- Book_ID +---> Author_ID Title | Author Author_ID -+ If I open the "Books" table, I see "Author_ID" by number. I can create a view, and see "Title" and "Author", in what OOo names "views", but they are read only. Further more, once created the view, I can't go back and change/add relations, it shows a different view of it, one that shows only "Title" and "Author" as Text[Varchar], but not where they come from and their relations, as if it were a new table. Useless. :-( - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7bNPtTMYHG2NR9URAtyyAJ4w/QUFLhVMmA1VnqvmA6WWQUuzHgCfX5kW jb6R8pmUgQx0ipPiwK7fICo= =fJuz -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Monday 17 September 2007 00:50, Carlos E. R. wrote:
The Sunday 2007-09-16 at 19:16 +0200, primm wrote:
The frontend to MySQL is just wonderful. Have to have it. The report creation is almost there too. Dragging to create relationships is better than Access Can't swap now. . .
Rekall or OOo base?
Because in OOo I can't use tables with relations in read/write mode, only read.
I can create a "View" like this from two tables:
Books Authors ------- --------- Book_ID +---> Author_ID Title | Author Author_ID -+
If I open the "Books" table, I see "Author_ID" by number. I can create a view, and see "Title" and "Author", in what OOo names "views", but they are read only. Further more, once created the view, I can't go back and change/add relations, it shows a different view of it, one that shows only "Title" and "Author" as Text[Varchar], but not where they come from and their relations, as if it were a new table.
Useless. :-(
-- Cheers, Carlos E. R.
Ooo base. It shows you (teaches you) the correct sql too in sql view. No lo se. Pues a mi me ayuda. Lynn x -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Sunday 2007-09-16 at 19:16 +0200, primm wrote:
The frontend to MySQL is just wonderful. Have to have it. The report creation is almost there too. Dragging to create relationships is better than Access Can't swap now. . .
Rekall or OOo base?
Because in OOo I can't use tables with relations in read/write mode, only read.
Nope, I can do data entry without too much of a problem from the database view. Clunks a bit however....
I can create a "View" like this from two tables:
Books Authors ------- --------- Book_ID +---> Author_ID Title | Author Author_ID -+
Got something which does something similar....
If I open the "Books" table, I see "Author_ID" by number. I can create a view, and see "Title" and "Author", in what OOo names "views", but they are read only. Further more, once created the view, I can't go back and change/add relations, it shows a different view of it, one that shows only "Title" and "Author" as Text[Varchar], but not where they come from and their relations, as if it were a new table.
Useless. :-(
Not entirely..., Main gripe is that under the hood is some OpenOffice scripting... but the documentation for the scripting language is to put it at its politest sparse the last time I looked at it .... There are somethings I would like to do (e.g. put in a template selector for a default template) and do something about path handling so I do not have to create different versions of the same template for Windows and LInux.
- -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG7jojasN0sSnLmgIRAg7RAJ97OeawBpQ7I9+Gp3LCXzgl+wUq2QCfQN/9 lUcax0YO2GUc61/1GH7baBw= =pAyS -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Monday 2007-09-17 at 09:26 +0100, G T Smith wrote:
Because in OOo I can't use tables with relations in read/write mode, only read.
Nope, I can do data entry without too much of a problem from the database view. Clunks a bit however....
I can write to single tables, not those with relation active. I'll try to explain again... My Library "Libros" table (simplified) is shown like this: Title Author_nm - ------------------ --------- Robots and Empire 1 Rendezvous with Rama 2 I can create a new entry, but I have to look up manually the number of the corresponding author, and write up the number, not the name. Do you see what I mean? This is useless. I can create a table view, that combines two tables, like this: Books Authors ------- --------- Book_ID +---> Author_ID Title | Author Author_ID -+ Now, the view shows correctly: Title Author - ------------------ --------- Robots and Empire Asimov Rendezvous with Rama Clarke But it is Read Only. Again, useless. Do you understand the problem now? All the above works perfectly, and much faster and with less complexity, with Rekall. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7lWNtTMYHG2NR9URAipdAJ9et5xM6nflBQ/HBUjojZ0BapFegQCcD4jO H7TLaQruX4d7Ezhsg2gg7qA= =XZLd -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Monday 2007-09-17 at 09:26 +0100, G T Smith wrote:
Because in OOo I can't use tables with relations in read/write mode, only read. Nope, I can do data entry without too much of a problem from the database view. Clunks a bit however....
I can write to single tables, not those with relation active. I'll try to explain again...
My Library "Libros" table (simplified) is shown like this:
Title Author_nm ------------------ --------- Robots and Empire 1 Rendezvous with Rama 2
I can create a new entry, but I have to look up manually the number of the corresponding author, and write up the number, not the name. Do you see what I mean?
This is useless.
I can create a table view, that combines two tables, like this:
Books Authors ------- --------- Book_ID +---> Author_ID Title | Author Author_ID -+
Now, the view shows correctly:
Title Author ------------------ --------- Robots and Empire Asimov Rendezvous with Rama Clarke
But it is Read Only. Again, useless.
Do you understand the problem now?
I understand the problem. I have a form with a sub-form linked via an index... Whenever I select an entry in primary form I see all relevant entries linked in the sub-form... Can edit and update records in both form and sub-form..., Table structure is roughly Table A Index, data Table B Index, Link to A index, data Form to Sub form relationship based on linking field 1 to field 2... Your structure implies a read only join... Adding a new subform entry is clunky... and adding primary entries is definitely very clunky indeed (when committing a new entry tend to keep ending up on first record in table, so you have to go to the last entry and continue from there).
All the above works perfectly, and much faster and with less complexity, with Rekall.
- -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG7l3vasN0sSnLmgIRAi7rAKCU0Z47X/YIQTQBAkvfVpd9nQw+WgCfVcGp w3mgcRYtdjW1w1IWFdkxDW4= =zNWm -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Monday 2007-09-17 at 11:58 +0100, G T Smith wrote:
Do you understand the problem now?
I understand the problem.
I have a form with a sub-form linked via an index... Whenever I select an entry in primary form I see all relevant entries linked in the sub-form... Can edit and update records in both form and sub-form...,
Hum! I tried via forms, but I couldn't get it right.
Table structure is roughly
Table A
Index, data
Table B
Index, Link to A index, data
Form to Sub form relationship based on linking field 1 to field 2...
Your structure implies a read only join...
Huh? Rekall does it read write just fine. 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.
Adding a new subform entry is clunky... and adding primary entries is definitely very clunky indeed (when committing a new entry tend to keep ending up on first record in table, so you have to go to the last entry and continue from there).
Mmmm... - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7wHTtTMYHG2NR9URAhvCAJwMdb+v/gMEio1jDX6Gs+2kHucIaACghzQg XR5k75gBrWZ9/y52wuqRc3E= =y9Y3 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Monday 2007-09-17 at 11:58 +0100, G T Smith wrote:
Do you understand the problem now? I understand the problem.
I have a form with a sub-form linked via an index... Whenever I select an entry in primary form I see all relevant entries linked in the sub-form... Can edit and update records in both form and sub-form...,
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 :-) <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)...
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.... However a question remains.... how do you handle something like?... Programming Perl, by Larry Wall, Tom Christiansen & Jon Orwant ... :-) In OpenOffice you can currently build (very) basic data entry forms, and generate queries and reports for incorporation into OpenOffice documents (not something I think you can do with ReKall). On the other hand I would definitely not consider OpenOffice for your requirement.... The two things have somewhat different focuses.
Adding a new subform entry is clunky... and adding primary entries is definitely very clunky indeed (when committing a new entry tend to keep ending up on first record in table, so you have to go to the last entry and continue from there).
Mmmm...
- -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG749lasN0sSnLmgIRAqjkAJ9WE+z+RFlpeCwAyd3GhAA6E8MYPQCg01Q6 kta3JiZKmnAm/wq1OjuzDdk= =EMP5 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----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@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Carlos E. R. wrote:
I need a manual for dummies... O:-)
http://www.bestwebbuys.com/The_Complete_Idiot's_Guide_for_Dummies-ISBN_9781580081740.html?isrc=b-search ;-) -- Use OpenOffice.org http://www.openoffice.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-09-18 at 09:02 -0400, James Knott wrote:
Carlos E. R. wrote:
I need a manual for dummies... O:-)
Pity I can't browse it a bit... - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG8OP3tTMYHG2NR9URAmDBAJ4oBXzh9WgbF/MURdnf+QXRJRZDgACfTesc wZ6DQFYpuzfOWFPtitZhwhA= =ZV4N -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Tuesday 2007-09-18 at 09:42 +0100, G T Smith wrote:
<snip>
I need a manual for dummies... O:-)
I do have the OpenOffice.org for Dummies book ... bloody useless on this aspect ....
<snip>
< more snip>
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
Tend to use the latter kind of "link table" a lot... I have come across a number of references to fields holding array values, but at the moment MySQL does not support this. Postgresql apparently does. Suspect this may also be a bit beyond the ordinary user... <snip>
On the other hand I would definitely not consider OpenOffice for your requirement.... The two things have somewhat different focuses.
Pity.
Agreed..
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.
Define easy :-| with Access one spent as much time dealing with effects of the last patch as dealing with getting Access do something one expected.. I have also used used Lotus Approach which although radically different from Access was highly usable. Lotus Script was/is very tidy which is more than I can say for the Access Basic Scripting... Main complaint I have with OpenOffice is the scripting documentation is very poor.... <snip> - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG7+btasN0sSnLmgIRAj5VAJ997PUAlO0O84KcFOZe6gwBHd/+fwCgpFhT 7Vyxxs+8obc3nOfFTdZ6YGU= =Us3h -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-09-18 at 15:55 +0100, G T Smith wrote:
Carlos E. R. wrote:
<snip>
I need a manual for dummies... O:-)
I do have the OpenOffice.org for Dummies book ... bloody useless on this aspect ....
Too bad :-( I have just found a tutorial, in flash form, in "http://documentation.openoffice.org/tutorials/". I just saw the first two. By the way... Is there a way to watch swf files outside of firefox?
The complex one would be another linked table:
index to book index to authors ---------------+------------------- 1 10 1 11 1 23 1 47
Tend to use the latter kind of "link table" a lot... I have come across a number of references to fields holding array values, but at the moment MySQL does not support this. Postgresql apparently does. Suspect this may also be a bit beyond the ordinary user...
Array values! Now, that would be nice! :-)~ (slurp)
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.
Define easy :-| with Access one spent as much time dealing with effects of the last patch as dealing with getting Access do something one expected.. I have also used used Lotus Approach which although radically different from Access was highly usable. Lotus Script was/is very tidy which is more than I can say for the Access Basic Scripting... Main complaint I have with OpenOffice is the scripting documentation is very poor....
Easy to design a simple database. Point and click. When you get to want some complexity, then it becomes very dificult. An interface similar to what OOo base or rekall do, or tries to sometimes. I don't mean easy as in working correctly, though. I recogn M$ are good at designing interfaces, but that doesn't mean that later they work as intended or that there aren't gotchas. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG8CNctTMYHG2NR9URArg7AJ9haDPsS2u+OQh50/06XEzn/TF0PgCgiydA cjXsXio2cV1UdnIZW/SfUsM= =eov7 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Tuesday 2007-09-18 at 15:55 +0100, G T Smith wrote:
Carlos E. R. wrote:
<snip>
I need a manual for dummies... O:-)
I do have the OpenOffice.org for Dummies book ... bloody useless on this aspect ....
Too bad :-(
I have just found a tutorial, in flash form, in "http://documentation.openoffice.org/tutorials/". I just saw the first two.
By the way... Is there a way to watch swf files outside of firefox?
(now why didnt I think of this :-) ) .. No idea on swf... <snip>
Array values! Now, that would be nice! :-)~ (slurp)
ditto, <snip>
Easy to design a simple database. Point and click.
Follow you, the problem with this kind of easy is that it can be the equivalent of giving a working Uzzi machine gun to a three year old :-) (as in, database! what database? oops ). - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG8N54asN0sSnLmgIRAstNAJ9XGj3BpLZC5J9yyNN7XZ15ZoMSwACgziDS 1Vij5GPnnRHcDkC2Z6YDv4I= =XCIU -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Wednesday 2007-09-19 at 09:31 +0100, G T Smith wrote:
<snip>
Easy to design a simple database. Point and click.
Follow you, the problem with this kind of easy is that it can be the equivalent of giving a working Uzzi machine gun to a three year old :-) (as in, database! what database? oops ).
Yep. But I'm just seven years old when it comes to databases, so I want it ;-) - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG8OPBtTMYHG2NR9URAnTtAJ9DVHUD3JT+oE2WqY5xxe6qmehQDwCfTy0f hdFSdvRKAiCYMJbe+27ciTc= =TnUV -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
The Wednesday 2007-09-19 at 09:31 +0100, G T Smith wrote:
<snip>
Easy to design a simple database. Point and click. Follow you, the problem with this kind of easy is that it can be the equivalent of giving a working Uzzi machine gun to a three year old :-) (as in, database! what database? oops ).
Yep. But I'm just seven years old when it comes to databases, so I want it ;-)
As a brief aside I notice that IBM have just launched Lotus Symphony... (Speadsheet, Word Processor, Presentation Software) No apparent database support, SLES 10 support only, installation via bin and a min requirment of 1Gb memory :-( - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG8Qx1asN0sSnLmgIRAjcEAKCNnihgrvkF+un9bl5b+btnRKYf9gCgziYr tz3w6F59KYX77ha8jDkBNuo= =QkTH -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wednesday 19 September 2007 07:48, G T Smith wrote:
As a brief aside I notice that IBM have just launched Lotus Symphony... (Speadsheet, Word Processor, Presentation Software) No apparent database support, SLES 10 support only, installation via bin and a min requirment of 1Gb memory :-(
I remember Symphony for OS/2. I think that might have been happier with 1gig to if you used all the features. Too bad in those days 4meg was big. Odds are the spreadsheet will have some basic database features? Nick -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-09-18 at 14:18 +0200, I wrote:
I need a manual for dummies... O:-)
Found one. http://documentation.openoffice.org/tutorials/ The ones by David, on OOo databases, some tutorials in flash form. One of them explains how to create relations.
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.
We are supposed to go to "tools", "relations", and create them. Unfortunately, it pops up with: ] OpenOffice.org Base: Relation design ] ] The database does not support relations How come? I'm using relations on that same database (mysql) from Rekall. What's the problem with OOo? Is it that OOo can only use them on its own native format? I'm using OpenOffice_org-2.2.1-43.1 from suse (in 10.2) - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG8CcatTMYHG2NR9URArFDAJ4i6da7ueZDLSoE+mruIztWzvchAwCfZ9Eh 4qcfFcBmRCoWB9Cuj3VenBU= =lhme -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Carlos E. R. wrote:
We are supposed to go to "tools", "relations", and create them. Unfortunately, it pops up with:
] OpenOffice.org Base: Relation design ] ] The database does not support relations
How come? I'm using relations on that same database (mysql) from Rekall. What's the problem with OOo? Is it that OOo can only use them on its own native format?
I'm using OpenOffice_org-2.2.1-43.1 from suse (in 10.2)
I do remember being able to use this at one point, I am getting the same result now. - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG8N9/asN0sSnLmgIRAnW0AJwN9P4koJj+JmaAAVmkuEwNsVTCzACfTgqt Aqq3PQhTePW75z382eqzaqg= =393d -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (6)
-
Carlos E. R.
-
G T Smith
-
Hylton Conacher (ZR1HPC)
-
James Knott
-
Nick Zentena
-
primm