Rename the database in a BAM Mobile project

The BAM Mobile Project includes a SQLite database named mydatabase.db. Follow these steps to rename it.

  1. Create a BAM Mobile project.
    Select File > New > Genero BAM Mobile > BAM Mobile Project (.4pw). Provide a project name and location and click OK.
    A BAM Mobile Project is created. It includes a Project group with the following:
    • a Config library node containing the fglprofile file; and
    • a src/Database library node with two files: a database file (mydatabase.db) and a database meta-schema file (mydatabase.4dbx)
    It also includes a DatabaseMaintenance group containing a CreateDatabase application node, which contains the default database creation script mydatabase_sqt_x.4gl.

    The DBPATH environment variable is set for the project, specifying the location on disk where the default database file can be found: $(ProjectDir)\database;$(DBPATH)

  2. Rename the database and database meta-schema files to a name of your choosing.
    Under the src/Database node, right-click on the filename and select Rename. Provide the new name. Ensure you keep the proper file extension during the renaming process.

    When renaming, use lower case letters.

    For example, to create a database named "test", rename the files test.db and test.4dbx.
  3. Update fglprofile (located in the config node) to reference your new database name.
    For our example, this involves replacing "mydatabase" with "test":
    dbi.default.driver = "dbmsqt"
    dbi.database.test.source = "test.db"
    Save your changes.
  4. In the database meta-schema file (.4dbx), use the context menu to model the database by adding tables and constraints and save your changes.
    You can skip this step to create an empty database.
  5. Generate the create database script.
    Right-click on the database meta-schema filename and select Generate Database Creation Script. At a minimum, select SQLite as the target database; select or de-select other options as desired.
  6. Save the generated script in the $(ProjectDir)/databaseMaintenance directory, and insert the file into the project in the CreateDatabase application node.
    At this time, you can delete the mydatabase_sqt_x.4gl file, as it is no longer needed. To delete the file, right-click on the filename and select Delete from Disk. This option not only removes it from the project, but also removes it from the file system.
  7. Execute the CreateDatabase application.
    1. Select the CreateDatabase configuration node and rename the BinaryName property to match the 4gl script that you created. For example, if the script is called test_sqt_x.4gl, set BinaryName to test_sqt_x.
    2. Right-click the CreateDatabase configuration node and select Execute.
    The database is created. The status of the operation displays in the Output view.
  8. Use DBExplorer to verify that the database was created properly.
    This step involves connecting to your new database and executing a query. For example, if you created a table named "account", you could enter the SQL statement:
    SELECT * FROM account;