Re: [libreoffice-users] Adding fields to existing Base table

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]dboland9@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
    [3]dboland9@fastmail.fm
  --
  [4]http://www.fastmail.fm - Or how I learned to stop
  worrying and
                            love email again
  --
  To unsubscribe e-mail to:
  [5]users+unsubscribe@global.libreoffice.org
  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:dboland9@fastmail.fm
3. mailto:dboland9@fastmail.fm
4. http://www.fastmail.fm/
5. mailto:users%2Bunsubscribe@global.libreoffice.org
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
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - One of many happy users:
  http://www.fastmail.fm/help/overview_quotes.html


-- 
To unsubscribe e-mail to: users+unsubscribe@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