Create a table, insert some records, and open the SQLite file in a GUI program to see all the changes. Create new tables and forms using LibreOffice: !(ugly_form.png "Super ugly example form") Any time you save, all edits will occur on the SQLite file. This is fine-it's not actually saving the database, just the accompanying form data. Click on "Finish." LibreOffice will prompt you to save an `.odf` database. If you click on "Browse…", you should see the name of the SQLite database you set up as a DSN earlier. Click next to select which ODBC database to load. In the wizard, select "Connect to an existing database" and choose "ODBC": !(base_wizard.png "LibreOffice Base wizard") 8. Open LibreOffice and create a new Base database. The SQLite file is now accessible in any program that uses ODBC. Create a new key named "database" and use the full absolute path to the SQLite database file as the value: !(dsn_setup.png "DSN setup dialog") 6. Add a new driver using these settings: !(driver_setup.png "Driver setup dialog") 5. There are two that work equally well: () and (). Prior to OS X 10.5, Apple included one of these, but for whatever reason they stopped with Snow Leopard. The page includes a link to a precompiled version ( currently it says “Steve Palm kindly provided a build of version 0.9993 for MacOSX 10.
0 Comments
Leave a Reply. |