Your application will access the sample officestore
database. You must create a meta-schema file based on this database.
About this taskThe SQLite database file
officestore.db is located in
samples/OfficeStoreRes/database-sqlite/.
Note:
The samples directory can be found under
Documents/My Genero Files (on Windows®) or genero-files (on macOS™)..
You must create a
.4dbx schema file based on this database. The schema
file contains the information about the tables, columns, and relations of the relational database
that is needed by your application. It is used to create items in your Business Application Diagram
(
4ba).
-
Select .
The New Meta-schema dialog opens.
-
Complete the Meta-schema file
step.
-
Click on the File Browser icon next to the Meta-schema file
path field.
The Save File As dialog opens.
-
Navigate to your project directory and select the
database directory. Enter
officestore in the File
name field. Select Genero Database Schema
Files (*.4dbx) in the Save as
type combobox.
Important:
Make sure the file created is a .4dbx file,
because this is the database meta-schema file for generated
applications.
Click Save.
-
Ensure the Insert the file in the project check box is selected, select
the Database node, and click Next.
-
Complete the Connection
information step.
-
Select "SQLite" as the Database type.
The Database driver defaults to "dbmsqt".
-
Click on the File Browser icon next to the Database
file field.
The Choose database schema file dialog
opens.
-
Select the officestore.db file located in the
samples/OfficeStoreRes/database-sqlite/ directory and click
Open.
The database file is populated.
-
Click Test Connection to verify that the
connection is successful, then click OK to close
the connection test dialog.
-
Click Finish.
The
officestore.4dbx file is created and
opened.
Tip:
To make the diagram more readable, right-click inside the
.4dbx diagram and select
Layout.
-
Select .