Skip to content

Launching Database Builder

Synchronizing with Other DataFlex Tools

In development mode (i.e., DataFlex Studio is installed), Database Builder respects switches to another workspace made in other DataFlex tools. When the workspace has been switched in, say, the Studio while Database Builder is active, Database Builder will detect the switch when it regains focus. Database Builder will try to switch to the newly selected workspace automatically.

There are three possible results of this attempt:

  1. If there are no open tables in Database Builder, it will switch to the new workspace.

  2. If there are open tables, but none has been changed, Database Builder will show a warning that it will close all open tables to switch. After the user presses OK for this warning, Database Builder will close all open tables and switch to the new workspace.

  3. If there are open tables and one (or more) has changes, Database Builder will show an error message that the workspace has been changed but cannot switch to it because there are changes. After the user presses OK for this message, Database Builder opens in the workspace it was previously in (no switching occurs).

Selecting a Workspace

To select a workspace, choose Select Workspace… from the File menu and use the Open a workspace dialog to find and select the appropriate Studio Workspace (.sws) or Workspace (.ws) file. The dialog disappears, and the name of the selected workspace is shown in the title bar.

Recently Used Workspaces

Database Builder maintains a recently used list of workspaces. To select a recent workspace from this list, choose Recent Workspaces from the File menu. Now, select the workspace you wish to work in.

Launch Parameters

At deployment time, you won't typically have the Studio installed and need to synchronize multiple tools to the same workspace. You can either use the menu options above or start Database Builder from a shortcut.

You can launch Database Builder using these parameter options:

  • -x Load the workspace specified.
  • -h Show command line help: Database Builder will show an information box with all parameters that can be passed.
  • -t Load the table with rootname.
  • -t Load the table with number.
  • -d DataDictionary support on.
  • -d- DataDictionary support off, table editing on.
  • -p Popup Database Builder panel where can be:
  • MSSQLConnect
  • DB2Connect
  • ODBCConnect
  • NewTable

Example

This shortcut (or command line call) will launch Database Builder and open the 'Order Entry' sample workspace:

"C:\Program Files (x86)\DataFlex 18.2\Bin\DBBldr.exe" -x"C:\DataFlex 18.2 Examples\Order Entry\Programs\Config.ws"