[libreoffice-users] Re: Base Field Defaut Disables Save
u...and so quickly we reach the limits of my understanding here. Whoops. So I thought I was demonstrating that command with that one line I referenced. Does it help to put the whole table setup? Or would all the tables be helpful? Again here I used the Mental Health Clinic Database (from the tutorial) as a guideline. This table is an intermediary to deal with a many to many relationship. CREATE TABLE Vulnerability ( Vuln ID INTEGER NOT NULL, Vulnerability INTEGER NOT NULL, VulnInstance NUMERIC(10) DEFAULT 1, CONSTRAINT PK_ISSUE PRIMARY KEY (Vulnerability, Vuln ID ), CONSTRAINT FK_ISSUE FOREIGN KEY (Vulnerability) REFERENCES Issue Type (Issue ID), CONSTRAINT FK_SCAN_VULN FOREIGN KEY (Vuln ID) REFERENCES Scan (Scan ID) ); -- View this message in context: http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3264635.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Hi, On Thu, 2011-08-18 at 04:52 -0700, ncreamer wrote: CREATE TABLE Vulnerability ( Vuln ID INTEGER NOT NULL, Vulnerability INTEGER NOT NULL, VulnInstance NUMERIC(10) DEFAULT 1, CONSTRAINT PK_ISSUE PRIMARY KEY (Vulnerability, Vuln ID ), CONSTRAINT FK_ISSUE FOREIGN KEY (Vulnerability) REFERENCES Issue Type (Issue ID), CONSTRAINT FK_SCAN_VULN FOREIGN KEY (Vuln ID) REFERENCES Scan (Scan ID) ); I was able to get the code fragment CREATE TABLE Vulnerability ( Vuln ID INTEGER NOT NULL, Vulnerability INTEGER NOT NULL, VulnInstance NUMERIC(10) DEFAULT 1) to generate a table in Base but it did not accept the default value. When I copied the table and edited the copy, forcing the default value to be 1, it did accept the value. When I created a table by design view, it would not display the assigned default value. Testing the query in other databases (MariaDB and SQLite) it worked erratically, SQLite displaying the default value and MariaDB not displaying it. Checking my references, the syntax is correct of Column_name data_type [column_attributes]. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 17/08/11 20:53, ncreamer a écrit : Hi, Helpful thread - thank you. Any idea why not even the SQL tool will set a default value for me? I spent lots of time in the Base_Tutorial and created tables with SQL. The field that follows does NOT have a default value of 1 and, as this thread confirms, I can't set it in design mode. https://bugs.freedesktop.org/show_bug.cgi?id=38337 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 17/08/11 20:53, ncreamer a écrit : And this : http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=26194#p119217 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Helpful thread - thank you. Any idea why not even the SQL tool will set a default value for me? I spent lots of time in the Base_Tutorial and created tables with SQL. The field that follows does NOT have a default value of 1 and, as this thread confirms, I can't set it in design mode. FieldName NUMERIC(10) DEFAULT 1, All my tables/relationships, etc. execute without fail (after much trial error) but when I create entries in this table, I do not get a default value of 1. Any ideas? Mac OS 10.5.8 LO 3.4.0 Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3262592.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Hi, On Wed, 2011-08-17 at 11:53 -0700, ncreamer wrote: Helpful thread - thank you. Any idea why not even the SQL tool will set a default value for me? I spent lots of time in the Base_Tutorial and created tables with SQL. The field that follows does NOT have a default value of 1 and, as this thread confirms, I can't set it in design mode. FieldName NUMERIC(10) DEFAULT 1, All my tables/relationships, etc. execute without fail (after much trial error) but when I create entries in this table, I do not get a default value of 1. Any ideas? What was the SQL command you used to create the default values in your table? It might be a problem of the initiation query. Mac OS 10.5.8 LO 3.4.0 Thanks. -- View this message in context: http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3262592.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 04/06/11 17:41, Tom Davies a écrit : Hi all, Better off looking here first : https://bugs.freedesktop.org/buglist.cgi?quicksearch=libreoffice+database As you can see, there are a good number of Base bugs, many of which have are still unresolved since the very first releases of LibreOffice. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
I'm suffering the same problem. OO Base 3.2 workd fine. Having upgraded to LO 3.3 (and tried OO 3.3), any date format field cannot have a default date set. My prior embedded HSQL database (from OO2.x, used in OO3.2) doesn't work - the set default date enters nonsense in the field, which obviously then errors since it doesn't fit the date format. Hence, no new entries can be made. Deleting the default date works OK. However, I don't enter the date in my form - it is always today - so I simply edit the table each day before starting data entry. This no longer works, making LO3.3+ unusable for me. The workaround of using SQL each day is unsatisfactory (and this was not necessary for 3.2). (Tried LO/OO3.3 on Ubuntu 10.10 11.04) -- View this message in context: http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3022557.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Hi :) Have you already posted a bug-report about this or is there already one at http://wiki.documentfoundation.org/BugReport It might be worth posting one even if you don't have time to search through for one. Triagers are quite smart about doing that and linking similar bugs together. Good luck and regards from Tom :) - Original Message From: ugm6hr ugm...@hotmail.com To: users@libreoffice.org Sent: Sat, 4 June, 2011 8:59:37 Subject: [libreoffice-users] Re: Base Field Defaut Disables Save I'm suffering the same problem. OO Base 3.2 workd fine. Having upgraded to LO 3.3 (and tried OO 3.3), any date format field cannot have a default date set. My prior embedded HSQL database (from OO2.x, used in OO3.2) doesn't work - the set default date enters nonsense in the field, which obviously then errors since it doesn't fit the date format. Hence, no new entries can be made. Deleting the default date works OK. However, I don't enter the date in my form - it is always today - so I simply edit the table each day before starting data entry. This no longer works, making LO3.3+ unusable for me. The workaround of using SQL each day is unsatisfactory (and this was not necessary for 3.2). (Tried LO/OO3.3 on Ubuntu 10.10 11.04) -- View this message in context: http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3022557.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
On Tue, May 3, 2011 at 3:05 AM, Alexander Thurgood alex.thurg...@gmail.comwrote: Le 03/05/11 00:24, John Shabanowitz a écrit : Try the solution suggested in this thread : http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=26194 i.e. Go to the Tools - SQL menu entry Enter an ALTER table command to set the default value for each field as you desire. e.g. alter table T2 alter column C2 set default 0; HTH, Alex Good Info. I thought it was a bug because of inconsistent behavior. When you connect to a MySQL database using Base and Oracle's MySQL connector, you can ALTER, CREATE, and DROP tables from the GUI in Base. I need to use a reference when writing SQL so sometimes the GUI is the easiest way to get up to speed, especially with complex queries. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 06/05/11 13:42, John Shabanowitz a écrit : Hi John, Good Info. I thought it was a bug because of inconsistent behavior. When you connect to a MySQL database using Base and Oracle's MySQL connector, you can ALTER, CREATE, and DROP tables from the GUI in Base. I need to use a reference when writing SQL so sometimes the GUI is the easiest way to get up to speed, especially with complex queries. Unfortunately, even with the Mysql connector (which is actually pretty good it has to be said) there will be times where you will have to resort to SQL. Watch out for bugs / deficiencies in the in-built OOo SQL parser when executing complex queries, you will have to switch the parser off to get any meaningful result, even with the Mysql connector, and there is a strange date calculation issue floating around that makes adding and subtracting dates error prone. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 03/05/11 14:55, Tod Hopkins a écrit : Hi Tod, I would very much like to use Base, but I'm at the edge of having sufficient knowledge to make it work. It appears that in order to make Base work for me, I will have to study MySQL and use it as my backend, with base as a front end. Well, it isn't an absolute requirement to use a db server to get something useful out of Base, but if you want to carry on using HSQLDB (as provided by LibO or in its latest version incarnation of 2.0), then I would strongly advise you to read the tutorials on the OpenOffice.org forum about setting up mixed-mode functionality. At present, even using mysql has its quirks/problems when working from within LibO/OOo, but so far, with my own use of mysql, the only things I've managed to kill in the past have been my ODB files (most notably forms) and not my data. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Thanks for the advice. By mixed-mode you mean the use of HSQLDB front end with MySQL (or other) backend? I've been trying to read what documentation there is. Not much. I find that as soon as I get beyond what I already understand, there is a presumption that I that I have a working knowledge of SQL, which I don't. So, since my goal is multi-user database, for which I now see that I need MySQL anyway, I figure I should turn to learning MySQL. Cheers, tod On May 3, 2011, at 9:21 AM, Alexander Thurgood wrote: Le 03/05/11 14:55, Tod Hopkins a écrit : Hi Tod, I would very much like to use Base, but I'm at the edge of having sufficient knowledge to make it work. It appears that in order to make Base work for me, I will have to study MySQL and use it as my backend, with base as a front end. Well, it isn't an absolute requirement to use a db server to get something useful out of Base, but if you want to carry on using HSQLDB (as provided by LibO or in its latest version incarnation of 2.0), then I would strongly advise you to read the tutorials on the OpenOffice.org forum about setting up mixed-mode functionality. At present, even using mysql has its quirks/problems when working from within LibO/OOo, but so far, with my own use of mysql, the only things I've managed to kill in the past have been my ODB files (most notably forms) and not my data. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted Tod Hopkins Hillmann Carr Inc. todhopk...@hillmanncarr.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Hi :) Our Documentation Team will need volunteers that have some understanding of Base. There is likely to be help available in transferring OpenOffice's community documentation into our Alfresco content management system. Documentation goes through a series of stages before reaching proof-reading. A document is downloaded from Alfresco, edited in Writer or something and then re-uploaded either to the same stage or moving it on one stage until it reaches final proof-reading. Screen-shots can't be done in Windows but that still leaves a lot of small edits that can make a huge difference. If anyone following or involved in this thread is willing to give it a try then please feel free to join the documentation teams mailing list. Regards from Tom :) From: Tod Hopkins hopl...@hillmanncarr.com To: users@libreoffice.org Sent: Tue, 3 May, 2011 15:17:59 Subject: Re: [libreoffice-users] Re: Base Field Defaut Disables Save Thanks for the advice. By mixed-mode you mean the use of HSQLDB front end with MySQL (or other) backend? I've been trying to read what documentation there is. Not much. I find that as soon as I get beyond what I already understand, there is a presumption that I that I have a working knowledge of SQL, which I don't. So, since my goal is multi-user database, for which I now see that I need MySQL anyway, I figure I should turn to learning MySQL. Cheers, tod On May 3, 2011, at 9:21 AM, Alexander Thurgood wrote: Le 03/05/11 14:55, Tod Hopkins a écrit : Hi Tod, I would very much like to use Base, but I'm at the edge of having sufficient knowledge to make it work. It appears that in order to make Base work for me, I will have to study MySQL and use it as my backend, with base as a front end. Well, it isn't an absolute requirement to use a db server to get something useful out of Base, but if you want to carry on using HSQLDB (as provided by LibO or in its latest version incarnation of 2.0), then I would strongly advise you to read the tutorials on the OpenOffice.org forum about setting up mixed-mode functionality. At present, even using mysql has its quirks/problems when working from within LibO/OOo, but so far, with my own use of mysql, the only things I've managed to kill in the past have been my ODB files (most notably forms) and not my data. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted Tod Hopkins Hillmann Carr Inc. todhopk...@hillmanncarr.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
MySQL is quite simple once you get started. Makes it much easier with a tool like Webmin. We started extensively with the old Lotus Approach and then migrated to PHP/MySQL for general cross platform browser access. I keep looking at Base, but it hasn't reached the state of Approach so haven't dived in. steve On 4/05/11 12:55 AM, Tod Hopkins wrote: I would not have figured that out. The first thread suggests the preferred method for setting a default would be at the form level rather than at the table design level anyway. I will look to see if that can be done now. Makes sense to me. I would very much like to use Base, but I'm at the edge of having sufficient knowledge to make it work. It appears that in order to make Base work for me, I will have to study MySQL and use it as my backend, with base as a front end. Cheers, tod On May 3, 2011, at 3:13 AM, Alexander Thurgood wrote: Le 02/05/11 23:08, Tod Hopkins a écrit : It appears that the UI default value setting capability available through the table editor/designer is not propagated to the underlying database by design, see this bug report : http://openoffice.org/bugzilla/show_bug.cgi?id=108100 And it also appears that this will not be fixed any time soon, at least not in the OOo code, given the work that would be required to fix it, so it is probably even less likely to be done in the LibO code where there are no specialist db developers AFAIK. Currently, the only correct way to set a default value in the underlying db is to issue a corresponding CREATE TABLE or ALTER TABLE statement via the Tools - SQL menu entry. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted Tod Hopkins Hillmann Carr Inc. todhopk...@hillmanncarr.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 03/05/11 21:25, John Shabanowitz a écrit : Hi John, Why can't Windows screen shots be accepted for the documentation? Is the Windows version of LibO that much different from the Linux and Mac versions? It has nothing to do with differences in versions, but rather Microsoft Corp's unwillingness to allow use of parts of its UI in screenshots for free (as in libre) documentation. This has been previously discussed on the LibO Documentation mailing list, and other LibO lists, as well as several years ago on the OOo community mailing lists. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Field Defaut Disables Save
Le 03/05/11 19:46, Steve Edmonds a écrit : Hi Steve, MySQL is quite simple once you get started. Makes it much easier with a tool like Webmin. We started extensively with the old Lotus Approach and then migrated to PHP/MySQL for general cross platform browser access. I keep looking at Base, but it hasn't reached the state of Approach so haven't dived in. steve Yes, Base is still one hell of a long way from anything near what Approach was or FileMaker Pro, for that matter. It is a shame that IBM did not pursue the Approach way of doing things when it decided to put its money into developing Lotus Symphony. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Field Defaut Disables Save
Hi John, On Tue, 3 May 2011 15:25:35 -0400 John Shabanowitz john...@gmail.com wrote: On Tue, May 3, 2011 at 10:42 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: [...] Why can't Windows screen shots be accepted for the documentation? Is the Windows version of LibO that much different from the Linux and Mac versions? It's not because it is so different from Mac or Linux versions but because Microsoft has a very certain view about copyright and using screenshots made on a Windows system in the documentation for a competing product. The germanophone OOo project asked MS Germany about this and the answer we got was that we would need permission from MS. (André, if I'm wrong, please correct me). So to avoid any copyright issues we decided to use only screenshots made under Linux. Sigrid -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted