Howdy, Well, IMO, dumping the DB with a simple script command is great if you are migrating the data but for exporting data:
You need to look at the HSQLdb documentation on TEXT TABLES and the SELECT INTO construct. Using that you can export all of a table or use the standard query functions to export a subset of records or to join records from multiple tables into a single export file. I hope that helps, Drew On Thu, Mar 19, 2020 at 12:26 PM Dan Lewis <[email protected]> wrote: > Page 6 of chapter 10 Database Maintenance contains this section. Can > anyone explain how to actually do this? I can use SCRIPT 'database > name'; and then SET SCRIPTFORMAT TEXT. This reduces the database folder > within the *.odb file. But how do I use Tools > SQL after these two steps? > > Dan > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
