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? 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 https://wiki.documentfoundation.org/Documentation/Publications#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 <dbola...@fastmail.fm> 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 > dbola...@fastmail.fm > > -- > http://www.fastmail.fm - Or how I learned to stop worrying and > love email again > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > > -- To unsubscribe e-mail to: users+unsubscr...@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
