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: [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
