To create a table, select Create New Table... from the Database Menu or Database Toolbar or Table Explorer Context Menu or click the Create New Table button in the Table Explorer tool bar. The Create New Table dialog is activated up and you are prompted to enter the following information:
This tab is for creating SQL tables via Managed Connections. If you use drivers that support Managed Connections, we recommend doing so. The Studio and other DataFlex tools maintain Managed Connections and INT files for you and eliminate a lot of manual maintenance.
Choose the Connection Id to connect to. If you have multiple Managed Connections using the same Connection Id, the Enabled version will be used.
This button opens the SQL Connection Manager, which lets you configure Managed Connections for a workspace using Connection IDs.
This shows you the Connection String configured for your Managed Connection, so that you can verify it before proceeding.
Enter the name of your new table. This name should conform to your database's table name rules and should be unique for the current database.
Enter the database schema name.
DataFlex’s file list uses a table number to address each table. Each data table in your application must have a unique table number within the supported range (1-4095, except for reserved numbers 48-50 and 251-300).
You are prompted with the lowest unused table number. You can accept the default or choose a different number. The table number determines the locking order for any group of tables that need to be locked. This ensures that tables are always locked in the same order.
Clicking the search icon on the right will increment the table number to the next highest unused table number.
If you are using the embedded database, the Root Name refers to the directory name of the new table (excluding the file extension). Normally, the table name and this root name will be the same. The Root Name must conform to operating-system filename rules.
Enter the Root Name of the table you are creating. In certain cases, you may wish to enter a drive letter and path (up to a maximum of 40 characters in total). If you do not enter a drive and path, then the workspace Data path will be used to specify the table's location. Normally, you will not specify a drive letter or path.
If you are not using the embedded database, then the filename refers to the name of the file that records a description of the table to the database driver. Special modifiers can be added to the filename to specify the type of driver. Normally, you will not edit this field as it is better to accept the defaults that are entered for you in this dialog. Refer to your database driver documentation for specific information.
Check this if you wish to make this a Recnum table. Recnum tables are a legacy attribute of the embedded database and not needed for SQL tables, especially brand new ones that were not converted from the embedded database.
This tab is for creating embedded database tables.
DataFlex’s file list uses a table number to address each table. Each data table in your application must have a unique table number within the supported range (1-4095, except for reserved numbers 48-50 and 251-300).
You are prompted with the lowest unused table number. You can accept the default or choose a different number. The table number determines the locking order for any group of tables that need to be locked. This ensures that tables are always locked in the same order.
Clicking the search icon on the right will increment the table number to the next highest unused table number.
DataFlex’s file list uses a table number to address each table. Each data table in your application must have a unique table number within the supported range (1-4095, except for reserved numbers 48-50 and 251-300).
You are prompted with the lowest unused table number. You can accept the default or choose a different number. The table number determines the locking order for any group of tables that need to be locked. This ensures that tables are always locked in the same order.
Clicking the search icon on the right will increment the table number to the next highest unused table number.
If you are using the embedded database, the Root Name refers to the directory name of the new table (excluding the file extension). Normally, the table name and this root name will be the same. The Root Name must conform to operating-system filename rules.
Enter the Root Name of the table you are creating. In certain cases, you may wish to enter a drive letter and path (up to a maximum of 40 characters in total). If you do not enter a drive and path, then the workspace Data path will be used to specify the table's location. Normally, you will not specify a drive letter or path.
If you are not using the embedded database, then the filename refers to the name of the file that records a description of the table to the database driver. Special modifiers can be added to the filename to specify the type of driver. Normally, you will not edit this field as it is better to accept the defaults that are entered for you in this dialog. Refer to your database driver documentation for specific information.
This tab is for creating SQL tables via non-Managed Connections. If you use drivers that support Managed Connections, we recommend doing so. The Studio and other DataFlex tools maintain Managed Connections and INT files for you and eliminate a lot of manual maintenance.
Choose the database type to connect to. Drivers already loaded in the Studio will display in the combo list. Selecting Load Driver... will open the Configure Database Drivers dialog to allow you to load other drivers.
This button opens the SQL Connection Manager, which lets you configure Managed Connections for a workspace using Connection IDs.
This activates a connection dialog to help you to configure the connection string to your particular database. This is the recommended method of editing your connection string. The dialog will be one of DB2 Connection Properties, MSSQL Connection Properties, ODBC Connection Properties or Pervasive.SQL Connection Properties.
This shows you the Connection String configured for your Connection, so that you can verify it before proceeding.
The Connection String is a set of property=value pairs that is used to establish a connection to your desired database. The particular set of property=value pairs is determined by the particular database that you are connecting to. Refer to your database driver documentation for specific details.
Enter the name of your new table. This name should conform to your database's table name rules and should be unique for the current database.
Enter the database schema name.
DataFlex’s file list uses a table number to address each table. Each data table in your application must have a unique table number within the supported range (1-4095, except for reserved numbers 48-50 and 251-300).
You are prompted with the lowest unused table number. You can accept the default or choose a different number. The table number determines the locking order for any group of tables that need to be locked. This ensures that tables are always locked in the same order.
Clicking the search icon on the right will increment the table number to the next highest unused table number.
If you are using the embedded database, the Root Name refers to the directory name of the new table (excluding the file extension). Normally, the table name and this root name will be the same. The Root Name must conform to operating-system filename rules.
Enter the Root Name of the table you are creating. In certain cases, you may wish to enter a drive letter and path (up to a maximum of 40 characters in total). If you do not enter a drive and path, then the workspace Data path will be used to specify the table's location. Normally, you will not specify a drive letter or path.
If you are not using the embedded database, then the filename refers to the name of the file that records a description of the table to the database driver. Special modifiers can be added to the filename to specify the type of driver. Normally, you will not edit this field as it is better to accept the defaults that are entered for you in this dialog. Refer to your database driver documentation for specific information.
Check this if you wish to make this a Recnum table. Recnum tables are a legacy attribute of the embedded database and not needed for SQL tables, especially brand new ones that were not converted from the embedded database.
Click the OK button to proceed. The Studio will create a new table and activate the Table Editing dialog to allow you to set up columns, relationships and indexes.
When the new table is saved, the Studio will create a data dictionary class for the table. For a description of the naming conventions used to create the data dictionary class see Configure Studio.
Click the Cancel button to close this dialog without creating a new table.
Click the Help button to display this help topic for creating a new table.
Configuring Database Connection