Version 2.4.2.1469

 Added support for SQLAnywhere schemas so as to allow you to differentiate all Tables and all Views

 Added a new TOKEN for Port to SQL in CODE add at the END of any code line !DMCSKIPLine and DMC will NOT parse this ONE LINE

 Added code so as have the system tray icon reflect what is happening during a TXA parsing (dmc being hidden)

 Added code to protect values within quotes during TXA parsing of a Port to SQL task

 Added a NEW COLOR definition in the THEMES to allow you to define what COLOR you want your BUTTONS (background) to be

 Added new feature during Port to SQL : during the first dctx reading phase which displays the tobe sql dct - now you will have a report list of any duplicate KEY names found in your dct

 Added a NEW Table level option TOKEN - DMCLevel - during a Port to SQL define the ORDER in which the Tables will be treated and mainly the Data Transfer Profiles order (Parent-Child)

 Added in CSV export a stop or continue message

 Corrected the BLOB Temp Table in IMDD support to work properly (with a HUGE improvement in time taken to process Tables with Blobs)

 Added support for a concat detail during data transfers the necessary code to accept a value of <SP> to be used as a separator for a SPACE

 Changed SQL reserved words browse - form to open up a form and not EIP and added a filter on this browse to display - ALL - level 1 or level 2

 Changed the Port to SQL default project NAME to also reflect the full path name of the DCTX used

 Removed from "select task" the manage your profiles as that was redundant with the navigation panel link

 Changed the override defaults on Date and Time detections during a clone to SQL task to display icons showing what will happen

 Corrected the code used to LOCATE a record in Table Lists (main wizard)

 Corrected a bug when in Viewer mode and the table contained less than 50 records - the Viewer would report "all records read"

 Corrected a bug in ODBC driver where a string(2000) in PostGreSQL was seen as a memo (a TEXT in sql language)

 Corrected a bug in ODBC driver which sees a PostGreSQL ByteA blob as a string

 Corrected a bug during SQL normalizations on "Next" and "Previous" buttons

 Corrected a bug in Port to SQL on data type when using MySQL which could break the dctx generated

 Corrected a bug in CSV export for the progress bar to display properly

 Corrected a bug in SQL DB Backup edit and restore scripts

 Corrected a bug during Clone to SQL when a BLOB was not placed at end of table structure in SQL

 Corrected a bug during Port to SQL on a DCT without any relations - then columns were badly renamed and ended up with empty screens

 Corrected a bug during Port to SQL on MySQL PRIMARY keys

 Corrected a bug during Clone to ASCII from a TPS

 Corrected a bug during SQL to TPS cloning on table names (tps side would be "dbo_customers" - now it is simply "customers")

 Corrected a bug so as to display the progress bar during data transfers when DMC reads the SOURCE side data after clicking on the Transfer button

 Corrected a bug in displaying properly lifetime versions when using american dates and when US Dates were used (on expiry dates)

 Corrected a bug in ODBC connections on our test server

 Corrected a bug when PostGreSQL was used with Binary Blobs

Version 2.4.1.1433

 Added code to allow during data transfers a CONDITION on a TIME column to be DYNAMICALY changed reading from an INI file (like for the DATE Dynamic Conditionals)

 Added code to workaround an SV ODBC driver bug which "sees" an sql2008 TIME column as a STRING(8)

 Corrected a bug during Port to SQL where DMC would GPF at the beginning of the task

 Corrected and reviewed all the code during a Clone to task (DAT to DBF mainly) when DMC would not "see" properly the created destination table

 Corrected a bug during Access Tables reading when a KEY was declared on a MEMO column

 Corrected a bug during cloning to PostGre SQL - adding quotes around column names xxxxx up everything while reading the table

 Corrected a bug in VIEWER when saving to file on SQL tables (nothing would be saved)

 Corrected a bug on any Oracle DB query - DMC would GPF

 Corrected a bug during Port to SQL on tables containing MEMO columns (these where not ported)

 Corrected a bug in data transfers if the user clicked on "check mappings" then a GPF would happen

 Corrected a bug in Port to SQL on DATE and TIME columns (sql2008) when they are used in a KEY

 Corrected a bug in Port to SQL when a TPS table contains a column with a leading '_'

Version 2.4.0.1425

Full support of CamelBackedCasing in Table Names - Keys and Columns to better reflect structures.

Port to SQL now has OPTIONS (with explanation text) to better allow you to select the "step" to perform

Port to SQL - new option to re create all SQL Tables

Port to SQL - new demo application to DEPLOY using the "INI" file technique (change the INI values for each end-users and NOT the code)

Port to SQL - Save your settings - restore settings to/from INI files

Port to SQL - NEW button to allow you to CLEAR all internal FLAGS

Port to SQL - TWO new TOKENS DCT in Column LEVEL option : DMCSetNULL and DMCSetNotNULL

Port to SQL - support the possibility to use the Description from DCT to be used in SQL script as a COMMENT

Port to SQL - Exporting your Project now backs up any previous files

Port to SQL - support for FRB and taboga barcode template in TXA parsing

Support to COLOR a profile with any Mapping Option in Orange (extended to all 'normal' options)

STOP message if you are trying to connect to a SQL 2008 Server with the 2005 driver "SQL Driver" in Viewer Data Transfers and Port to SQL

Support for SQLAnywhere "server" typed ODBC connections with TCPIP additional setting

Support code during SQL Table clones - readings and DB backup to accept a table Name with a numeric as first character

Support for CHARSETS in XML exports

NEW display information string during Data Transfers to inform you of Records processed / Records to process

NEW setting to allow users to define the GROUPING value they want for formatting figures

NEW button in Settings (global) to RESET all DMC settings to Factory defaults

NEW button in Port to SQL to RESET all sql settings to factory defaults

Setting to read in SQL environment "Tables" or "Views" or "Tables and Views"

Setting to define if Clones and DCT creations would be "Uppercased" "Lowercased" "CamelBackCased"

Data Transfer - End of a Batch Processing (except when in silent mode) display the LOG file generated

Port to SQL - during selection of destination DB - a filter the list to display ONLY the connections corresponding to the selected SQL TYPE in previous screen

Data Transfers - method in internal SQL class to get from the server the DateTime FORMAT used so as to be able to transfer and format accordingly

SQL Reserved words come in TWO levels to allow you to tweak as per YOUR needs (move between levels is allowed)

NEW 'use all sql reserved words' setting in Port to SQL - dct screen - and in settings sql tab

All main tasks are encapsulated in a "long job" animated GIF display without showing the background screen

Support during the SQL clone and DB backup to REORDER the sql columns (blobs mainly) exactly as they are in SOURCE side

Support during an SQL DB backup task to use the original BIT type of data when applicable

Long Task options - define thresholds above which DMC will process the current task minimized

Clone to SQL - IF the TableName or the SchemaName is an SQL reserved word then DMC will QUOTE all

Support in MsSQL for schema names which are SQL Keywords - example on a schema called 'tran'

Full support for 'illegal' schema names throughout

Data Transfers - FUNCTION to allow you to define a FORMAT string which can be manually defined ie @P###-####-###P (or anything you want)

Data Transfers - OPTIONS in Functions : STORE function result and CONCAT all previously STORED results

Data Transfers - OPTION : when you use a multiple column multiple function, you can STORE this end result to use it as an External table lookup VALUE

Profiles - a NEW column called NOTES to allow the user to add comments

Data Transfers - code to protect the user from adding an external table lookup AFTER other functions if the STORED value of previous functions is NOT checked

Data Transfers - code to protect the user from adding an external table lookup AFTER other functions when the last function is not STORED

Clone DB or FOLDER - added SQL "quotes" to allow all types of names to "pass" and for CamelBackCasing

Clone a DB or a FOLDER - added a 'drop table' script to make your clones easier (no use deleting the existing tables)

Support for case sensitivity in MsSQL servers

Port to SQL - when an SQL ERROR is received by the server STORE this error and ADD it in the "include file" at the bottom to allow you to see an error exists

Data Transfers - External "Replacement groups" Search & Replace the possibility to use <SP> (for a space) *several* times in *either* Search and/or Replace values

Data Transfers - "store" column values in display Q's even when a condition is NOT met.

Settings - Define the SIZE of the MEMO columns to use when CLONING from an ACCESS table to TPS - DAT

Port to SQL - NEW tokens in DCT for procedures to not be changed : DMCSkip and DMCNoRename and DMCSetIdentity and DMCSkipIdentity and DMCSetGUID

Port to SQL : setting to define Table Name and Owner strings directly in DCT and not in INCLUDE file

Port to SQL : all settings can be accessed from "main" settings module

Port to SQL : Setting to define if KEYS will be case sensitive or not

Port to SQL : all necessary files are copied for you in YOUR "destination" folder

Port to SQL - Exporting the project : if any previous export was done those are archived and all necessary tables extracted from DMC folders and copied to YOUR destination folder

Transfer Data with BLOBS : setting to define TWO thresholds to trigger switching from the (fast) IMDD temp table to a (slower) TPS one - Nb. Blobs and Nb. Records

Transfer Data - NEW function(s) to De Punctuate a STRING - Replace and Compact a STRING

Port to SQL - NEW button "proceed" to avoid stepping through each "advanced" tabs

Transfer Data - mapping CONDITIONS a NEW option checkbox (visible ONLY IF a SORT ORDER is defined in mappings) to tell DMC that this Condition is to be used as BREAK when NOT MET

Transfer Data - IF the Number of records is BIGGER than the setting THEN a popup Message warns you that the Transferred data TAB will not be displayed (speed up processing)

Port to SQL - Toggle display on KEYS with autoinc in Normalized DCT display screen

Navigation Panel changes to allow direct access to tasks

When Editing a profile, after you close the main window you will be brought back to the Profiles module

All DCT and TXA parsing's are speeded up

Port to SQL - code to take you directly to the DESTINATION folder when asking for a TXA parsing to select the TXA(s)

Port to SQL - support in a DMCSkip procedure to still rename any Procedure CALLS

Changed DCT and code when DELETING a Project so as to speed up the task

Corrected code on ExternalColumn Names when they are camelbacked and quoted so as to removed these quotes from DCTX and TXD

Changed code in reading access tables so as to DISPLAY a structure WITH BLOBS but to still use in Viewer or data transfers as source and dest a STRING

Changed code so as not to display in Port to SQL (Regenerate TXD option) the Select TXA button

Support for Novegian characters

Support during a clone to same sql or during an SQL DB backup task to support FLOAT and NVARCHARS

Support for an MsSQL Identity column which cannot be updated (sql limitation) - added a new flag (internal) so as to avoid adding this column in the update script

SQL environment - select a RADIO to display only Tables or Views or Both - refresh automatically the List

Code so as to allow you to revert to the MRU list when you close the Viewer (coming from there)

Data Transfers - code to protect the user from using a Condition on a STRING column and using a NON quoted value

Port to SQL - support of PROTOTYPES and PARAMETERS when parsing TXA's

SQL Backup : added a "master" sql script containing ALL individual scripts to allow a one click restore (available in create ONLY scripts)

Clone to ASCII and XML : detect DATE columns in a STRING source and offer to change it to a DATE data type

"Restore a Profile" -> "Edit a profile" (name change)

Changed the display and sort order in ODBC connections drop down when creating a new one

Project & Profiles a new COLOR for you to distinguish when a Profile has Conditions or Functions or Concats

Port to SQL - depending on the SQL type of server selected in DCT parsing when you are in the "select destination server" screen - ONLY related connections are displayed

CHANGED all DMC distant SQL servers (all will be changed for you automatically) to use a new dedicated server (speed)

Corrected a bug when a MEMO column was present in VIEWER to allow inserting an RTF data type.

Corrected a bug where Port to SQL would do nothing DCT parsing if the first table was NOT tagged

Corrected code so as to clone a BYTE to an INT when working with MySQL (a TINYINT in MySQL does NOT allow entering data over 1 char sized)

Corrected a bug during DB/Folder cloning to SQL on SQL reserved words on Columns and keys and table Names

Corrected a bug during SQL DB Backup on IDENTITY columns and on component casing

Corrected a regression bug during all SQL Clones (including Port to SQL) - all keys would not be cloned resulting in generated DCTX not being good

Corrected a bug during data transfer from X to ASCII where the MEMO columns were not transferred

Corrected a bug when creating a table from TEXT would fail if a Column name contained the word 'file' and was used in a KEY

Corrected a bug when a profile was edited and when an ASCII Table was used as source (DMC would GPF)

Corrected a bug when a profile was saved and when External GROUPS were used

Corrected a bug when a TPS superfile table name contained a -

Version 2.3.3.1273

 Full support for DAT-TPS Tables with a STRING,OVER in the structure

 Full support for DAT-TPS Table with GROUPS within GROUPS upto 6 CHILD levels

 Full support for DAT-TPS Tables with DIMMENSIONED GROUPS (which Topscan cannot read)

 Full support for SQLAnywhere version 9

 Full support for IBM DB2 version 9.x

 NEW ODBC connection TYPE of DSN - allows you to test on any ODBC driver - like SQLite for example

 Full support for SQL KEYS on a BLOB column - a warning will be displayed and the KEY will NOT be added in the structure allowing these Tables to be used.

 Full support for DIMENSIONED GROUPS and GROUPS within GROUPS during a Clone to SQL Task or a Port to SQL one

 NEW MAPPING Option to allow you to define if an EMPTY SQL column should be transferred with an EMPTY STRING or the DEFAULT NULL value.

 Added a NEW option to allow you to define if you want to Port to SQL your Primary Key's (only applicable to MsSQL) as CLUSTERED or as NONCLUSTERED

 Port to SQL : Added support to read in DCT if a Column has a Validity check set to NONZERO then the SQL Column is defined as 'NOT NULL'

 NEW SETTING : SQL accessing DB's the possibility to use authentication at DB level (source and destination sides)

 NEW SETTING : SQL Define the STRING COMMAND to SEND to the SQL server for the authentication (source and destination are the same)

 Full support to DROP any KEY on a GROUP and WARN the user in the SQL Reserved Words TXT popup - recommended to change in original DCT

 Support in TXD parser from c7 back to c6 (clarion 6 -> clarion 7 DCT bug) where a PICTURE(xx) is defined with a missing @

 Support in TXD parser from c7 back to c6 (clarion 6 -> clarion 7 DCT bug) where an OPTION and RADIOS are used in REPORTCONTROL but the OPTION line is missing

 NEW Clarion 7 AddIn to allow you to have online docs and contacts available within the Clarion IDE

 Changed ODBC connection for ACCESS and EXCEL from DSN to a FULL DSNLESS one - select the MDB or XLS/XLSX file and all is done

 Added a NEW option in SQL settings to allow you to define if during Data Transfers (sql coded) DMC should break the loop at 1st error or carry on

 Port to SQL : NEW Destination FOLDER selection to COPY all relevant files generated by DMC so as to let you have all available in YOUR selected Folder.

 Port to SQL : Added the 'storing' of the SQL Type of server used between sessions.

 Port to SQL : when you ask to Create Profiles a new BUTTON to allow you to REFRESH the list after a physical folder table name change

 Projects & Profiles MODULE a NEW checkbox which allows you to RUN a selected project or profile SILENTLY (not a saved option)

 Projects & Profiles MODULE a NEW BUTTON allowing you to RESTORE a SELECTED Profile (mappings etc) exactly like when you use a "Restore Profile" task

 Corrected in LOGS any SQL errorcode sent back so as to allow you for better understanding of errors during a data Transfer Task

 Corrected a bug in TXA parsing when using SQL 2008 and DATE or TIME columns

Version 2.3.2.1231

 Port your Application to SQL added a Wizard like Step by Step to allow you an easier navigation for this feature

 Port your Application to SQL added the possibility for you to DEPLOY your new SQL Tables to your end users machines (with the Runtime Engine)

 Port your Application to SQL added support for more c6 to c7 DCT errors (GLOBALS without a DRIVER - OPTION control with several predefined values etc ...)

 Port to SQL - TXA parsing added many Legacy "cases" and during table Name matching (Create profiles) a NEW display order to make selections easier.

 Port to SQL - Save your settings to HD and Restore settings from HD

 Changed code used when Transferring Data to FireBird with BLOBS and on Alias Tables in Port to SQL

 Added in Settings the possibility to access all SQL Normalization options and to define the CASE to use for DCTX and TXD generation

 Added in Settings the possibility to display or not at the end of a data transfer the records (save time if not needed)

 Corrected several bugs in Clone to SQL (Firebird) when a BLOB NON Binary column existed in Table or when a DynIndex is the last key

Version 2.3.1.1205

 Port your Application to SQL added a Casing setting to retain existing CamelBackCased Names

 Port your Application to SQL added a setting to ADD a NEW Column (GUID or Identity) ONLY if NO Primary Key

 Port your Application to SQL added when replacing a STRING to Date to extract and use the DCT PICTURE in Data Transfer

 All Tasks performed in DMC are now called from the Procedure TIMER which makes the IDE totaly responsive

 Clone to CSV added a renaming Destination Table option

 Corrected a bug in Mysql CLW file generation and in ShellExecute (removed a Wait Flag)

Version 2.3.0.1193

 Port your Clarion Application to SQL (with full SQL code compliancy and Data Transferring option) Clarion 5.5/6/7 - ABC and legacy support

 Full Support for MIMER SQL

 Advanced level Capitalizing during Data Transfers (define always uppercased - always lowercased and direct replacements "cases")

 During a Clone Table to SQL you have the possibility to apply SQL normalization settings (as per your defined options)

 When any Task is opened or running the Main Frame Close Application button will popup a message to Close the Task

 Corrected several bugs in existing code (Identity on SQL Tables - Colons in Column Names etc...)

Version 2.2.0.0

Table & Sql DB level STRUCTURE Comparison tasks

Compare a Tps-Dat Table to another Tps-dat Table (superfiles and encrypted ones are allowed)

Compare a Tps-Dat Table (superfiles and encrypted ones are allowed) to a single or MULTIPLE SQL Tables

Compare an SQL table to a single or MULTIPLE SQL table(s) - INTER SCHEMA comparisons is possible

Compare an complete SQL DataBase to another SQL DataBase (Tables are "linked" by NAME)

All DATE & TIME selections have a VISUAL tip field to allow you to SEE the FORMATED data

Global setting to allow during a CLONE to SQL Task to lowercase all NAMES

Global (and popup message) option to allow you to define if an TXD/DCTX Export will be generated in lowercased NAMES

SQL environment (Ctrl+Q) & Compare Structures (Ctrl+C) MENU & Navigation Panel with keyboard shortcuts for more user friendly IDE

During a CLONE DB & Folder task all KEYS are dynamically renamed (if needed) to avoid DUPLICATES

Workaround a BUG found in Clarion ODBC driver on reserved words used in KEY NAMES - "PRIMARY" would be read as "KEY_PRIMARY"

All Temp tables created by DMC to store Columns HIDE/UNHIDE are now stored in a special DMC temp folder (avoids cluttering your data folders)

Corrected a bug in Destination side TPS Multitables encrypted when asking to store the password

VIEWER on a MEMO field - now you can also see the content of an RTF - HTML and XML properly displayed

SQL Backup task when BLOBS were present

Clone Folder with superfiles & during an ACCESS type clone & Export to CSV from Viewer

Version 2.1.0.0

MENU with keyboard shortcuts for more user friendly IDE

Global Setting to Hide / Unhide the Left Navigation Bar - Entirely resizable Frame (smaller than 800x600) is supported

SQL VIEWS are available as SOURCE and in Viewer with their definition as declared in the sql server (NEW Tab)

Create an SQL VIEW from a manual query and Export the Structure to TXD / DCTX

In Projects : button to REPAIR all when master key no longer works (seems like conditions - functions are no more available in a profile)

Full support for MsSQL SCHEMAS (displayed as dboTableName etc ...)

Full support for Excel 2007 /2010 files and illegal characters in column names (spaces and accentuated letters) [also in ASCII Tables]

Changed code to reflect sql server error messages during sql manual queries

Changed the button (and code) in SQL environment 'SQL Data' Tab to close the TAB (and revert to main one) instead of closing the module.

All Temp tables are now IMDD to speed up all tasks and processing

Support for Oracle - Postgre SQL and MsSQL SCHEMAS in Cloning task (allows you to clone a Table from SchemaA to SchemaB)

Mapping option : Function lookup on external Table to act as FILTER

Wizard Create table - Portable version creation - Memo columns transfer - TPS (prefixed tables) during Viewer and Transfers - space in MsSQL Table Names

Version 2.0.0.2

Data Transfers : Support for multiple LINKED conditions (IF or ELSIF)

Data Transfers : Support for Manual Condition Builder (allows you to build the most complex conditions)

Data Transfers : Support for multiple LINKED functions

Data Transfers : Support for LINKING a Condition (or a "set" of conditions) to a Function (or a "set" of functions)

Data Transfers : Support for a Function of a DEFAULT value - to PARSE (n) th. word & to CONCATENATE within Brackets

Data Transfers : Support for DEFORMATING a Date or a Time (enter values in readable format and let DMC work)

Data Transfers : Support for DYNAMIC changing the VALUE of a CONDITION (create a condition with Dates as "limits" & change those dynamically from an INI file)

Bug in Viewer when a CSV export was done & XML BLOB columns not being exported properly

Version 2.0.0.1

Support for postgre sql server side default values (let the server do the work) - when such defaults exist : do not map the column as the server will do it.

In system bar the quantity of RAM used by DMC

Register your Serial through eMail support (from DMC itself) and phone.

In a Manual SQL Query now DMC will add a Primary Key on the 1st Column of the Result Set (import in dictionary to use as a View)

DMC is now compiled with the possibility to use MORE than the 2Gb limit (useful on LARGE Tables)

Global setting to refresh progress bars each percent (and not each 10% as defined by default) and another one to define Nb Records to read before an INSERT in SQL data Transfers.

Support for postgre BLOB columns

Changed the DMC Folder Tree Structure to allow all XP machine users to have all DMC table structures updated (FM3 refused to update some when the path was over 100 chars.)

Version 2.0.0.0

Backup an entire SQL DataBase in a single Task : create all INSERT CREATE TABLE scripts - ZIP them all (password protection) and Upload the Zip by FTP

Clone an entire SQL DataBase (multiple Tables selection) to ANY existing or NEW other SQL DataBase in a single Task.

Clone an entire FOLDER containing DAT and or TPS Files (multiple Tables selection) to ANY existing or NEW other SQL DataBase in a single Task.

Multiple Tables Data Transfers (SQL DB or a FOLDER containing DAT and or TPS Files) to existing SQL Tables in a Single Task.

During Data Transfers to SQL perform EXTERNAL TABLE LOOKUPS to retrieve values and use in the current Table's Selected Column

Register Application is entirely new and much easier to use at ANY time on ANY machine - use your DMC site credentials and request your Serial Number

New FUNCTIONS and CONDITIONS during Mappings : Conditional SUBSTRING - LEFT and RIGHT & FUNCTIONS on PERCENTAGES ( + - x / )

Checking for Illegal Characters during table operations is also performed now on TPS DAT DBF Tables

NEW Version of DMC : Runtime Engine for you to use from your application a small footprint engine and distribute to your end-users (SQL Backups - Viewer - Data Transfers etc...)

NEW DEMO application installer DMC Runtime Engine with Template TXA & TXD for Clarion 6 - Clarion 7 (it should work on Clarion 5 & 5.5 but not tested)

Template used for security and registration (secwin) is deleted and replaced by our own methods