|
Creation Wizard |
  
|
|
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
Click on New File to create one or use the 'Open Structure' checkbox to select an existing structure
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
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)
After clicking on 'Finish' the screen is refreshed like this
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 ...)
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
If the Column you are creating is "OVER" another one then please also use the appropriate checkbox to unhide those fields
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
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 ....
At this stage you must also know that in this Wizard 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
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
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
After the Table is created DMC will open up for you to work with it Windows Explorer in the relevant directory
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