Re: [libreoffice-users] Re: Writing programs for Base

I am surprised that Base is not a database program. I thought it was meant 
to be something like MS Access? Why is it included then in Libre Office?

I am also trying to create a database in Base (as I did before in Access), 
however I also run into problems I never had when using Access...

Raymond




From:   Andreas Säger <villeroy@t-online.de>
To:     users@global.libreoffice.org
Date:   25-08-2011 10:28
Subject:        [libreoffice-users] Re: Writing programs for Base



Since Base is not a database program, the first thing to know would be the
actual database to be used. An embedded HSQLDB is only one option, good
enough for simple demos and drafts but you don't really want to develop
anything serious for that.

Every "common database" (MySQL, Postgre,... and HSQLDB too) provides 
access
to external text tables by means of database structures pulling their
content from plain text files.
You can create a view which selects the wanted records from the text table
in the right order of columns.
In Base you can drag or copy the view icon over the target table's icon 
and
hit "Create".
A set of example files dealing with csv, Base and Calc:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727
[Example] Loading CSV into preformatted spreadsheets 
Files #1 and #2 resemble a text file linked to a (embedded) HSQLDB, 
editable
through an input form on a (embedded) Writer document.

Using some "common database", any "common scripting language" can update 
the
database with very few lines of code. No 350MB office suite required for
that.


--
View this message in context: 
http://nabble.documentfoundation.org/Writing-programs-for-Base-tp3283165p3283334.html

Sent from the Users mailing list archive at Nabble.com.

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



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