On Thu, Jul 10, 2014, at 03:51 PM, Tom Davies wrote:
Hi :) 1st thing is that Base is best when used 'just' as a front-end and with all the data in some back-end such as MySql/MariaDb, Postgresql, HsqlDb or whatever. Generally i think it should be possible to fill an existing field, in all rows, by using an action Query. However, i am really surprised to hear that a new field can't have zero-length or be completely empty. Which docs have you been reading? >From Getting Started, 4.0: Once tables have been created using the wizard, and data has been entered, editing them should be very limited. Fields can be added or deleted, but adding a field requires you to enter the data for that one field for every existing record with an entry for that field. Deleting a field deletes all the data once contained in that field. Changing the field type of a field can lead to data being lost either partially or completely. When creating a new table, it pays to create the fields with the correct names, length, and format before you add any data. Deleting a table removes all of the data contained in every field of the table. Unless you are sure, do not delete a table Chances are that they know tons more than me but jic it is FUD it'd be nice to know. The Base Guides are at [1]https://wiki.documentfoundation.org/Documentation/Publicatio ns#LibreOffice_Base_Handbook I hope someone with more experience of Base lets us know soon! ;) Regards from Tom :) On 10 July 2014 20:27, dave boland <[2][email protected]> wrote: I'm setting up a database that is small (three tables, may grow to 3GB over next year). I need a strategy to deal with the unknown, which is how to add fields to an existing table. I read in the docs that doing this can be painful and it is required to put something in each field for each record. Do I have this correct? If so, how do I handle the inevitable "...would you add..." that is sure to come within the next few months? I would add them now, but I really can't anticipate how many fields will be added or their requirements. In general, do other databases have similar restrictions? At some time, when I have time, I will consider MySQL, MariaDB, and others. Thanks, Dave -- dave boland [3][email protected] -- [4]http://www.fastmail.fm - Or how I learned to stop worrying and love email again -- To unsubscribe e-mail to: [5][email protected] Problems? [6]http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: [7]http://wiki.documentfoundation.org/Netiquette List archive: [8]http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted References 1. https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook 2. mailto:[email protected] 3. mailto:[email protected] 4. http://www.fastmail.fm/ 5. mailto:users%[email protected] 6. http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 7. http://wiki.documentfoundation.org/Netiquette 8. http://listarchives.libreoffice.org/global/users/ -- dave boland [email protected] -- http://www.fastmail.fm - One of many happy users: http://www.fastmail.fm/help/overview_quotes.html -- To unsubscribe e-mail to: [email protected] 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
