Skip to content

DataBase Builder 18.1

Convert Table Wizard

The "recnum or standard table" page now has two checkboxes: Define Primary Keys and Convert to Standard.

  • When using the Primary Key option, the converted table will have a Primary Key defined and a clustered index. This should be the same for both standard and recnum conversions.
  • During standard conversions, the recnum should be dropped, and the file primary index attribute should be set.

This enhancement allows developers to convert tables directly to Azure format with or without recnum. If you have system tables, there is one extra step: you must add an index to your system table. You can add that to the embedded table before the conversion by selecting a column that rarely or never changes. This is essentially what is required when connecting to Azure with no indexes (i.e., create a dummy index).

All Wizards

We ensured that the wizards are using the latest fonts, sizes, and images (this was overlooked during the font changes). This includes all of the DataBase Builder wizards and some of the Studio Wizards (e.g., Connect to Database, New Workspace, New Class, etc.).

Connect to Table Wizard

We modified the connect to table logic so it does not create a different logical name each time you reconnect to the same table.

  • Prior to 18.1, if you connected to a table and then removed the connection (without deleting the .int or .fd file), you would receive a new name upon reconnecting. This was particularly annoying for testing purposes and was noted in the forums as our random table connect naming scheme.
  • Now, the connection wizard checks to see if the logical name already exists in the filelist.

This means that .int and .fd files may now be overridden, which we consider a positive change.

Additionally, we now exclude system views from the list of views to connect to. This change only applies when connecting to MSSQL databases.