You can also replace hostname with the IP address of the server. See the documentation that came with the JDBC driver for more information.įor an Oracle database, the syntax of the URL is the name of the machine that runs the Oracle database. The syntax of the URL depends on the database type. In the Data source URL box, enter the location of the Oracle database server. You can also download the latest version from the Oracle web site. The JDBC driver class for the Solaris Oracle client version 8.x is located in the /product/jdbc/lib/classes111.zip directory. On UNIX, ensure that the Oracle database client is installed with JDBC support. To access the database from Windows, you need an ODBC driver. You can use a JDBC driver to access an Oracle database from Solaris or Linux. The driver classes must be added to LibreOffice in LibreOffice - Preferences Tools - Options - LibreOffice - Advanced. ) after each of these properties opens the Link fieldsĭialog, where you can choose the fields from the already defined ImageCategories Open the subform's data properties and you should see the Link master fields

At the moment, that's every single register in the table, but I'm interested only in the categories linked to a record opened in the main form. Now all the data fields in the subform access the ImageCategories Subform opens its properties, where you select Table , and enter the name of your new subform. In the Form Navigator, right-click MainForm A right-click changes the settings or adds subforms. Table into the form and display it like you see in Figure 6, surrounded by a red box.įigure 8: The Form Navigator shows an overview or the control elements in an entry mask. Instead, I will show how you can integrate the Categories It would be unwieldy to manually enter all the idįields for all the images in the ImageCategories When asked whether to automatically create a primary key for the ImageCategories To create this table, use the Create Table in Design View

You link both tables with what is called a pivot tableįields.

In this case, for such a simple table, you will not need to create a form. Enter the category names you want to use for your image collection – for example, 'Landscape,' 'Portrait,' 'Still life,' etc. , close it, and reopen it in data entry mode. Text field and – as already created in the Images As explained in the 'Relational Databases' box, you'll need two new tables to associate any number of categories to a set of images.

Libreoffice base sqlite