Set the environment variables

The database connection for this quick start requires the FGLPROFILE and DBPATH environment variables. FGLPROFILE specifies the configuration file that provides access to the sample databases. DBPATH specifies the location of the database file at runtime.

  1. Select Tools > Genero Configurations.
    The Genero Configuration Management dialog opens.
  2. Under Configuration Name, select a Desktop configuration.
  3. Edit the FGLPROFILE environment variable.
    1. Under Environment Sets, right-click on "Profile" and select Duplicate.
      An environment set called "Profile_2" is created. Double-click on "Profile_2" and rename it to "Profile - AccountTest".
      Figure: Duplicate the Profile environment set

      This figure is a screenshot of the Genero Configuration Management dialog, highlighting the "4.00.01 Desktop" configuration, the Duplicate button, and the "Profile - AccountTest" environment set.
    2. In the Environment Variables section, double-click on the FGLPROFILE variable.
      The Environment Variable dialog opens.
    3. The Value field needs to append the directory to the FGLPROFILE file to the existing FGLPROFILE directory list. Provide the directory for the FGLPROFILE file provided in the samples/OfficeStoreRes/ directory. The samples directory can be found under Documents/My Genero Files (on Windows®) or genero-files (on macOS™).
      Figure: Edit environment variable dialog

      This figure is a screenshot of the Environment Variable dialog where Type = "File List", Name = "FGLPROFILE", and Value = "C:\MyDocuments\My Genero Files\samples\OfficeStoreRes\fglprofile;$(FGLPROFILE)".
    4. Click OK to close the Environment Variable dialog.
      The FGLPROFILE environment variable is updated.
  4. Add the DBPATH environment variable.
    1. Under Environment Sets, right-click on "DB-SQLite" and select Duplicate.
      An environment set called "DB - SQLite_2" is created. Double-click on "DB - SQLite_2" to rename it to "DB - SQLite_AccountTest".
    2. In the Environment Variable section, click the green plus icon.
    3. In the Environment Variable dialog, specify a Type of Directory List and a Name of DBPATH.
    4. In the Value field, use the File Browser to open the Edit Directories dialog and find the path samples/OfficeStoreRes/database-sqlite/. The samples directory can be found under Documents/My Genero Files (on Windows) or genero-files (on macOS). Click OK.
      Figure: Editing DBPATH

      This figure is a screenshot of the Genero Configuration Management, Environment Variable, and Edit Directories dialogs.
    5. Click OK to close the Environment Variable dialog.
      The DBPATH environment variable is added to the environment set.
  5. Ensure the checkboxes for the "Profile - AccountTest" and "DB - SQLite_AccountTest" environment sets are selected (checked).
  6. Click OK to close the Genero Configuration Management dialog.