Creation Wizard

Creation Wizard

If you want to create a TOPSPEED or DAT or DBASE or ODBC SQL Table manually you can use our Creation Wizard to do so

After selecting 'Create table Wizard' you will prompted to either use an existing Structure or to create a new one with this screen

dmc_wizard_select

Click on New File to create one or use the 'Open Structure' checkbox to select an existing structure

dmc_wizard_open

If you do so you will be asked to choose any *.tps table contained in the Data Management\cgf_import\Structure directory ( please note that the table named cwstruct.tps is a reserved name for any new or current Structures)

If you want to create a New Structure here is the first screen offered

dmc_wizard_step1

Select the driver - format of the Table to create then enter all required fields in screen

If you select ODBC then you will be prompted to select the connection string to use

dmc_wizard_step4

After clicking on 'Finish' the screen is refreshed like this

dmc_wizard_step5

Follow the bottom line instructions and start by adding your Columns using the appropriate button

Clicking on any of those two buttons (cols. or keys) will open up a form for you to fill in the necessary information's

(please note that by clicking on the green arrow to save that Column or Key form, exactly the same form will be reopened for you to carry on creating your Columns or keys ...)

dmc_wizard_column_new

Fill in the name - select the Type and enter the length for this Column BUT if it is in a GROUP then first check on the appropriate box to unhide relevant fields

dmc_wizard_column_new_group

If the Column you are creating is "OVER" another one then please also use the appropriate checkbox to unhide those fields

dmc_wizard_column_new_over

Use the relevant drop down boxes to select the Column TYPE or the Parent Column Name or the Name of the Column this Column is "Over" depending on the cases

The drop down boxes are pre filled automatically with the relevant data for you to select from.

If you are in ODBC driver or not changes the Types allowed for example

For example filling in a simple LONG type Column named ID_FIELD will show like this

dmc_wizard_column_filled

IMPORTANT : please remember that column names MUST always be VALID ones (no spaces and no "fancy" characters also)

The moment at least one column is saved then you are allowed to create the table with the relevant button which is unhidden for you ....

dmc_wizard_create

At this stage you must also know that in this tool you can use Edit In Place on any NAME or SIZE column in the screen to help you go faster

Of course if you rename a Column name and if that Column is used in a KEY already declared, then the relevant field in the Key will also be renamed for you.

To create Key's, use the appropriate button and fill in the required fields

dmc_wizard_key_filled

You can use the KEY options : please remember that a PRIMARY Key cannot be No DUPlicates at the same time ....

In this version 1.0.0.3 the IDENTITY or AutoInc are not yet supported - it will be a coming version ONLY for ODBC MySQL and SQL

You simply drag a column from the right list box and drop it in the Key list box to add a column

You can add as many columns as you want

You can define if a Column is ASC or DSC with the relevant buttons (ASC is set by default)

You can move the columns Up or Down with the relevant buttons

The key columns chain is shown at the bottom of the screen....

The columns already selected are shown in red for visual help

If you drop a second time the same column nothing will happen - duplicates are forbidden)

From the moment you have several Columns and keys declared you may want to move your records up and down to better place them, use the relevant buttons to do so

dmc_wizard_create

Depending on your selection the Up or Down buttons will be disabled

When you have a GROUP Over a STRING containing columns the display will change to this for better visual help

dmc_wizard_group

IMPORTANT : When you select the first record (Table definitions) the relevant fields are opened for you to use - when any other record is selected all are hidden

When you add any KEY's they will automatically be placed just under the table definition record

When you add any MEMO or BLOB column they will automatically be placed between the KEY's and the Columns

Those form groups of records from which moving out is prohibited (a MEMO cannot be placed at the end of the table Structure for example)

When you are on a record and double-click in any non EIP enabled column then it will open the form for you to edit (or on the record ID col.)

When you create a GROUP "Over" a STRING (or another typed column) then only you have to be VERY careful with moving cols up and down as they are not "linked" together

When you create a GROUP "Over" another Column then the "Overred" Column MUST be before the Group column

You can of course delete any Column or key record by using the relevant button

If you want to save this as ... select the table definition first record then enter a new name in the Structure Name and press on "Save as..." - DMC will automatically close save open the new Structure table for you

If you want to open a new existing or empty structure at any moment simply use the "Open" button - DMC will automatically close this one and open the one you selected in selection screen (same as the first one shown)

When you click on "Create Table" and the Driver is TOPSPEED then a message will ask you if you want to visualize the created table - otherwise in ODBC a message will appear at the bottom of the screen.

A few demo STRUCTURES are included in the installer for you to better master this feature

VERY IMPORTANT INFORMATION (for DEMO version ONLY) : you are allowed to create Tables with ONLY 10 columns and or keys in demo mode and normally no extension can be given to this limit