Data Management Center

SQL COMPARE Table Structures : would any of you like to test this new BETA feature ?

Create an ODBC connection to any SQL(s)
Select Compare Structure task
Select a DB
Select a Table which will be acting as PARENT (others will be compared to this one)
Select a “destination” DB (acting as CHILD tables which will be compared to the PARENT one)
Click on Start task
Select 1 OR MULTIPLE Tables from this “destination” (child) DB
Click on OK and let DMC work

You then get a compared structure screen displayed in a TREE

Icons indicate if a Column or a Key-Constraint is identical or not

Differences are styled in BLEUE to better see them and a TIP is displayed when you HOVER the mouse on those columns

Open a node with a difference and “see” (another style applied) what is different (TYPE-PICTURE-SIZE-PRECISION-DEFAULT-PK-DUPE-BINARY-COLS in a KEY-NULL)

You have a “difference on Constraints-Keys” list at the bottom grouping all Constraints-Keys which are NOT matched by NAME
(these can be a renamed key or an extra one)

Same display for ‘extra’ columns found in CHILD Tables

You can also use Drag&Drop between these “different Constraint-Keys and their PARENT row so as to REPLACE them properly
(this is mainly done for the NEXT step to come ie : synchronization of table Structures)

And finaly you have a SendTo button to EXPORT a REPORT to predefined formats (XLS-HTML-WORD-CSV-PDF or to print etc….)

I would really appreciate any tests and feedback as this IS A NEW feature and many users asked for it and need it

I hope to have done it as easy to use and precise as possible for your everyday work when it comes to comparing tow or several SQL table structures

(it can be used for example to compare a Table in schemaA to any number of tables in any OTHER schema in the same DB or cross platforms on different flavors of SQL)

download link : email me and I’ll send it over

Install and use even in evaluation mode – this beta will let you compare upto 5 tables to a PARENT

Here is a small video (NO SOUND) to show all this
Here is the HTML page produced as resulting report (as not really easy to see in the video)

BTW : I have corrected a BUG when exporting to CSV with TAB as delimiter in the HEADER of the file (I exported a <TAB> instead of a <9> (Merci Bob)

I also added SQL Environment to the MENU AND Navigation bar with a keyboard shortcut of Ctrl+Q
I also added Compare Structures to the MENU AND Navigation bar with a keyboard shortcut of Ctrl+C
I also cganged the physical location of VIEWER TEMP files (holding your columns to Hide/Unhide) from current File Path to a DMC one so as not to clutter your data folders (Merci Abe)

Merci

DMC Version 2.1.0.0 Release Announcement

I am pleased to announce today the immediate availability of
DMC Version 2.1.0.0.
________________________________________

You can UPDATE to this NEW version from within DMC or you can use the full installer www.dmc-fr.com/programme/dmcsetup.exe

GOLD Version 2.1.0.0 released 12th. May 2010

NEW FEATURES

MENU with keyboard shortcuts for more user friendly IDE

Global Setting to Hide / Unhide the Left Navigation Bar – Entirely resizable Frame (smaller than 800×600) 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 Ms SQL SCHEMAS (displayed as dbo.TableName etc …)

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

Support for Oracle – Postgre SQL and Ms SQL SCHEMAS in Cloning task (allows you to clone a Table from Schema A to Schema B)

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

CHANGED

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

BUG FIX

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

For the Runtime Engine version (REQUIRES updating) we have also released a complete Installer Clarion 6/7 set of template (including TXD and TXA files) along with a standalone demo application ALL can test and download
________________________________________
NOTE :

Since Version 2.0.0.0 a COMPLETE NEW method of registration has been implemented to avoid all previous problems (some users had).

If your Maintenance Plan is expired you will need to renew your licence before updating.

If you do NOT have version 2 already installed you will need to “Register your Application” (with a NEW methods) after updating to this new Version :
1. Open DMC (will start in Evaluation mode)
2. Click in the Left Navigation Panel on “Register Application”
3. Click on the “Request serial from Web” button. (new in this version – register by email or phone)
4. In the registration screen use your DMC SITE credentials and then click on “Request” (if you do not remember them use the “Logins Forgotten” button and you will be taken onsite to request an email sent to your registered address)
5. You will be notified by a popup message of the status of your License.
6. DMC will then register the serial number received and close to reopen in Licensed mode.

CAREFUL : On a few XP machines the serial request returns a VALID result BUT it does not register it : we have added a second button for you to request your serial by EMAIL – use it and fill in the pre-filled email body with your personal credentials and click on the SEND button (do NOT forget to add your sending email address in the relevant entry field marked in RED) – we will generate the serial file and email it back to you!

All these registration steps can be seen here also onsite.

We remind you also that we have added a way of purchasing DMC with NO Maintenance Plan : Buy a “version” lifetime license and receive all minor version updates for free

You can also UPGRADE your version form Enterprise (or from Viewer to Enterprise then to RT) to the NEW Runtime Engine level (distribute DMC engine to your end-users and pilot-command it from your application)

If you need to renew or upgrade your licence or simply want to see all this by yourself, please visit this page http://www.dmc-fr.com/boutique_en.php
________________________________________

Do not hesitate to contact us for any help you may require (we can even connect to your machine with remote Desktop software (TeamViewer) to sort out any problem or request you may have)
________________________________________

Just a word to let you know the next version (2.1.0.0) will also fully support MsSQL schema’s

It will even be possible to clone a table from one schema to another

The display in all lists now for MsSQL is with the schema name appended to the table name ie : dbo.TableName

In the coming version 2.1.0.0 you will have a NEW feature for SQL : you will be able to access your SQL VIEWS as Source
You will also be able to CREATE SQL Views from an SQL query built in the SQL environment and create a Clarion TXD / DCTX directly so as to import the structure in your dictionary ….
Stay tuned

This is a small video to show you how the coming version 2.0.0.1 will update your older versions

Some users on XP machines had problems updating the structure of some of our tables (not all tables)

DMC data is installed by default under CSIDL_COMMON_DOCUMENTS ie : c:\documents and settings\all users\documents\CGF\Data Management

This ended up with a path to project tables of c:\documents and settings\all users\documents\CGF\Data Management\cgf_import\projects_profiles\mapdetD.tps
(which is a full table name of over 100 characters – this seems to be the source of the problem in capesoft FM3 template (sometimes only) as when we tested on a shorter path all was perfect)

So we decided to change the default installation path :

Delete subFolder “Data Management” (saves us 15 chars)

Rename “projects_profiles” to “prj” (saves us an extra 14 chars)

Our Installer (Setup Builder) will rename the Installation folder (if you have used it) , change the relevant registry keys and adds an entry in the DMC main ini file to inform the renaming has been done.

The new DMC 2.0.0.1 will read this ini file setting and do the needfull in your ODBC connections and Most recent tables and Mapping headers tables to replace the full table names as they should.

It will also detect if you have any Excel or Access connections and warn you that (as they are SYSTEM HKLM registry entries) it will not be able to write there to change them for you and you will need to take care of this folder change yourself in those DSN’s.

We are sorry for this but writing to LocalMachine registry in Vista upwards is not allowed (except if elevated which DMC is not).

Hoping this video explains all for you to better master and understand the reasons we had to do this structural change in DMC Folders (and how we solved it)

Merci

If you are doing tests on data Transfers on a BIG source table, to avoid losing too much time reading ALL the records after clicking on the “Transfer” button use this trick :
From the main frame toolbar click on the “Stop” button after enough records are read for your tests
This will send a message popup asking if you want to stop – answer yes
You will then be able to work on the records read in memory

Enjoy

Demo application on SQL coded External table lookups

I had already posted in the NG a small demo application and dct showing how to build the dct with variables and the app with dynamicaly changing SQL server connections :

It would let you connect – from a simple radio choice – to either MsSQL or MySQL or PostGre SQL

I decided to enhance this demo application with a cool addition : SQL coded (same table and another table) lookups

The main idea was to show that when you are in a FORM of your BROWSE and a record is read in the Clarion buffer, you still could do whatever you wanted (on ANY Table in the server) IF you used real SQL code.

_______________________________________________

The demo application will let you open 2 local TPS tables and the same tables in distant servers (the DMC test server – so all can connect if you have the ODBC driver installed)

The executable in the archive is compiled in Local mode so no worries for you to use it

Here are the steps to see the 3 different points :

1. Open the app and you have a radio choice on MsSQL – MySQL and PostGre SQL – select your favorite (CAREFUL : you need the relevant ODBC Driver installed) and click on “Distant Personne” to open this table

2. When the table is loaded in the browse, select any record and edit it with a double-click

3. when the form is loaded you will have TWO lists and TWO buttons to perform SQL LOOKUPS

• Same table Lookup (will query a few OTHER records from the same table and display them in the list)
• External table Lookup (will query a few records from ANOTHER Table – the Customer Table – and display them in the list)

This shows you that when the CLARION record buffer is occupied you can do whatever you want anywhere in the sql server IF you use pure sql code!

_______________________________________________

How all this works :

1. You must set up in dct all OWNER and NAME fields with variables which you prime in the application BEFORE opening the table (clarion side)

2. To dynamicaly switch from one server to another use a simple if else code like this one :

IF glo:sql_mysql = 1 ! SQL
! here if you change sql type to for example Oracle or PostgreSQL then simply change the connection string
glo:sql_owner = ‘driver=SQL Server;server=xxxxxxxxxxx\SQLExpress2005;uid=dmc_test;pwd=xxxxxxxxxx;database=dmc_test;’
glo:sql_personne = ‘dbo.personne’
glo:sql_customer = ‘dbo.customer’
ELSIF glo:sql_mysql = 0 ! MySQL
! here if you change sql type to for example Oracle or PostgreSQL then simply change the connection string
glo:sql_owner = ‘driver=MySQL ODBC 3.51 Driver;server=xxxxxxxxxxxxx;user=dmc_test;pwd=xxxxxxxxxxxx;database=dmc_test;’
glo:sql_personne = ‘personne’
glo:sql_customer = ‘customer’
ELSIF glo:sql_mysql = 2 !POSTGRESQL
glo:sql_owner = ‘Driver=PostgreSQL Unicode;server=xxxxxxxxxx;UID=dmc_demo;PWD=xxxxxxxxxxx;database=dmc_demo;PORT=5432;’
glo:sql_personne = ‘personne’
glo:sql_customer = ‘customer’
END

3. You declare and use a Q and a Dummy Table to match the resultset you want to receive and display

! DummyTable for Table Lookup
fTempSQL            FILE,DRIVER(‘ODBC’,'/TURBOSQL=TRUE’),PRE(ftempSQL),BINDABLE,THREAD
Record                 RECORD
CodePersonne             LONG
CodeSociete              LONG
Nom                      STRING(255)
END ! record
END ! file

! DummyTable for External Table lookup
fTempSQLE            FILE,DRIVER(‘ODBC’,'/TURBOSQL=TRUE’),PRE(ftempSQLE),BINDABLE,THREAD
Record                 RECORD
CUSTNUMBER                 LONG
TIECOTOASSBLY              LONG
BILL_COMPANY               STRING(255)
END ! record
END ! file

! Variables
szSQL               CSTRING(1024)
szConnectString     STRING(255)

! Q’s

qSQL                     QUEUE,PRE(TMPQ)
lCodePersonne              LONG
lCodeSociete               LONG
sNom                       STRING(255)
END

qSQLE                    QUEUE,PRE(TMPQE)
lCustNumber                LONG
lTiecoToAssembly           LONG
sBillCompany               STRING(255)
END

NOTE : the Q columns match the Dummy table Columns which also match the REAL table Columns queried – so it is as simple as adding extra columns here and there to retrieve more values !

4. Finaly a routine is used to send the query to the SQL SERVER directly – and THIS is the heart of all this demo – Clarion “knows” nothing of what the server does for you!

Local Table Routine :

SQL_Loopkup          ROUTINE

LOOP 1 TIMES
SETCURSOR(Cursor:Wait)
! Define connection string
! It CAN de defined on ANOTHER DataBase if NEED be – NOT tested here but should work
! I am nearly sure it could also perfectly work on ANOTHER SQL Server flavor (ie MsSQL or MySQL etc …)
! (here we define it to be the same as the existing connection)
szConnectString = glo:sql_owner

! Set the Owner of the Dummy Table
fTempSQL{PROP:Owner} = szConnectString

! Open the Dummy Table
CLOSE(fTempSQL)
SHARE(fTempSQL)
IF ERRORCODE() AND ERRORCODE() <> 52
MESSAGE(‘An error occurred opening the SQL file.  The error is: ‘ & |
ERRORCODE()     & ‘ – ‘ & CLIP(ERROR())     & |
‘<13,10>’                                   & |
FILEERRORCODE() & ‘ – ‘ & CLIP(FILEERROR()))
BREAK
END ! if

! Define the SQL QUERY
! we can even use the global variables used for the current connection here if we want ….
szSQL = ‘select CodePersonne, CodeSociete, Nom from ‘ & clip(glo:sql_personne) & ‘ where CodePersonne > 1250 and CodePersonne < 1260 ;’

! Set the Query to the Dummy Table
fTempSQL{PROP:SQL} = szSQL
IF ERRORCODE()
! define your errorcode code here
BREAK
END ! if

! FREE the temp RECEIVING Q
FREE(qSQL)

! LOOP on resultset
LOOP
NEXT(fTempSQL)
IF ERRORCODE() THEN BREAK END
qSQL.lCodePersonne  = CLIP(fTempSQL.CodePersonne)
qSQL.lCodeSociete   = CLIP(fTempSQL.CodeSociete)
qSQL.sNom           = CLIP(fTempSQL.Nom)
ADD(qSQL,qSQL.lCodePersonne)
?       ASSERT(~ERRORCODE(),ERROR())
END ! loop
CLOSE(fTempSQL)

?ListSQL{PROP:From} = qSQL
DISPLAY(?ListSQL)
SETCURSOR()
END ! loop

and the External Table routine :

SQL_LoopkupExt          ROUTINE

LOOP 1 TIMES
SETCURSOR(Cursor:Wait)
! Define connection string
! It CAN de defined on ANOTHER DataBase if NEED be – NOT tested here but should work
! I am nearly sure it could also perfectly work on ANOTHER SQL Server flavor (ie MsSQL or MySQL etc …)
! (here we define it to be the same as the existing connection)
szConnectString = glo:sql_owner

! Set the Owner of the Dummy Table
fTempSQLE{PROP:Owner} = szConnectString

! Open the Dummy Table
CLOSE(fTempSQLE)
SHARE(fTempSQLE)
IF ERRORCODE() AND ERRORCODE() <> 52
MESSAGE(‘An error occurred opening the SQL file.  The error is: ‘ & |
ERRORCODE()     & ‘ – ‘ & CLIP(ERROR())     & |
‘<13,10>’                                   & |
FILEERRORCODE() & ‘ – ‘ & CLIP(FILEERROR()))
BREAK
END ! if

! Define the SQL QUERY
! we can even use the global variables used for the current connection here if we want ….
szSQL = ‘select CustNumber, TiecoToAssbly, Bill_Company from ‘ & clip(glo:sql_customer) & ‘ where CustNumber > 8000 and CustNumber < 8300 ;’

! Set the Query to the Dummy Table
fTempSQLE{PROP:SQL} = szSQL
IF ERRORCODE()
! define your errorcode code here
BREAK
END ! if

! FREE the temp RECEIVING Q
FREE(qSQLE)

! LOOP on resultset
LOOP
NEXT(fTempSQLE)
IF ERRORCODE() THEN BREAK END
qSQLE.lCustNumber        = CLIP(fTempSQLE.CUSTNUMBER)
qSQLE.lTiecoToAssembly   = CLIP(fTempSQLE.TIECOTOASSBLY)
qSQLE.sBillCompany       = CLIP(fTempSQLE.BILL_COMPANY)
ADD(qSQLE,qSQLE.lCustNumber)
?       ASSERT(~ERRORCODE(),ERROR())
END ! loop
CLOSE(fTempSQLE)

?ListSQLExt{PROP:From} = qSQLE
DISPLAY(?ListSQLExt)
SETCURSOR()
END ! loop

___________________________________________

As you can see all this code is small and compact and very versatile

Depending on the type of sql server your query might require special differences – a simple google on your favorite sql will help you find those!

___________________________________________

Click here to download the archive containing :

demo application (6.3 9058)

demo dct

2 TPS tables

a TXA of the main procedures

_________________________________________

I hope this helps you step in the fantastic world of SQL and enjoy it as much as I do

JP

Mea culpa! Mea maxima culpa!

I did not take enough time to test all as it seems

Some users with a valid licence could NOT register them
Some users with an expired maintenance plan could NOT renew onsite

I have corrected all this in DMC and onsite and tested all this with several users.
________________________________________

Please re download and install this full installer over the existing version – it will allow you to register your valid licence.

CAREFUL : You can *NOT UPDATE* to this version from within DMC and *HAVE TO* use the full installer

Direct link to the installer

________________________________________

Please accept all my apologies for these oversights.

JP

Hi all,

I am very proud and happy to announce the immediate release of our latest version 2 of DMC _compiled using the NEW Clarion 7 IDE_ (latest version 6849)

DMC news for you : _GOLD Version 2.0.0.0_ – Birth of a NEW version – Multiple Tables level is added to your favorite tool

——————————————————————————–

*CAREFUL* :
If your Maintenance Plan is expired you will need to renew your licence.

We have entirely modified the registration method (Survey requested) in this version and you will need to “Register your Application” after applying this new Version :

1. Open DMC (started in Evaluation mode)
2. Click in the Left Navigation Panel on “Register Application”
3. Click on the “Request serial from Web” button.
4. In the registration screen use your DMC SITE credentials and then click on “Request” (if you do not remember them use the “Logins Forgotten” button and you will be taken onsite to request an email sent to your registered address)
5. You will be notified by a popup message of the status of your License.
6. DMC will then register the serial number received and close to reopen in Licensed mode.

All these registration steps can be seen here also onsite.
http://www.dmc-fr.com/HTML/register_your_licence.htm

We have also added a NEW way of purchasing DMC (Survey requested) with NO Maintenance Plan : Buy a “version” lifetime license and receive all minor version updates for free

You can also UPGRADE your version form Enterprise (or from Viewer to Enterprise then to RT) to the NEW Runtime Engine level (distribute DMC engine to your end-users and command it from your application)

If you need to renew or upgrade your licence or simply want to see all this by yourself, please visit this page
http://www.dmc-fr.com/boutique_en.php

——————————————————————————–

A _NEW MAJOR VERSION_ of DMC is available on our site and you are welcome to download and install it.

*CAREFUL* : You can _NOT UPDATE to this version from within DMC and HAVE TO use the full installer_
http://www.dmc-fr.com/programme/dmcsetup.exe

GOLD Version 2.0.0.0 released 1st March 2010
-  Backup an entire SQL Data Base 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 Data Base (multiple Tables selection) to ANY existing or NEW other SQL Data Base in a single Task.
-  Clone an entire FOLDER containing DAT and or TPS Files (multiple Tables selection) to ANY existing or NEW other SQL Data Base 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 / )

-  *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)

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

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

For the *NEW Runtime Engine* version we have also released a complete _NEW Installer Clarion 6/7 set of template_ (including TXD and TXA files) along with a standalone demo application ALL can test and download
http://www.dmc-fr.com/download_en.php
——————————————————————————–

FREE Data Management Center VIEWER license for all Clarion users

We want to remind you of this UNIQUE offer done to ALL Clarion users
http://www.dmc-fr.com/boutique_en.php?ref=283&cat=19&lang=en

It is a 3 STEP request : see for yourself by clicking on this link to open the FREE LICENSE page on site
1. Click on the “Add to Cart” button
2. Register on site (after clicking on the “Validate” button) -> [Create a New Account or open your existing account]
3. Finalize the “Request” (from “My Cart” in your Client area if you Create a New account OR after logging in from the “Next Step” Button)
(this will take you to the final NO PAYMENT request page)
We remind you this offer is for a FREE DMC VIEWER license with ONE YEAR full updates (maintenance Plan) included

——————————————————————————–

DMC Blog is on air -> see by yourself and make good use of this new communication

We will be adding new posts there with some Clarion Tips and Tricks as well as Many DMC ones of course.

——————————————————————————–

Do not hesitate to contact us for any help you may require (we can even connect to your machine with remote Desktop software (TeamViewer) to sort out any problem you may have)

JP

On Friday 5th. February from 9am to 11am PST we will do a webinar on DMC Version 2

here are the full details of what we offer you

1. a quick tour of the survey done on DMC – lessons to learn
link for all to take a look at all the results

as a first result of this survey
Secwin template has been removed to better allow you to install-reinstall DMC and replaced with a “home made” protection method
this new method will allow you register DMC without needing anything else than your personal login infos on our site
no more activation codes expiring etc …. or failures!

2. New Version 2 Features (mainly multiple table oriented)
a. Backup a full (or part of  an) SQL DB
this task will loop on all SELECTED tables in DB and create insert scripts for each record
option to add create table script
option to add drop table script
option to upload to any FTP server a zipped file containing all the sql scripts
b. Clone a full (or part of an) SQL DB
this task will loop on all SELECTED tables in DB and create scripts for each Table then execute them to create the New tables
option to Create a NEW DB (this will also create a new ODBC connection)
option to save all in a NEW Project (with all Profiles)
option to create a single TXD or DCTX from all the tables created Structures (for Clarion dct import)
option to RUN the created profiles and Transfer all DATA
c. Clone a full (or select your tables) FOLDER containing various TPS and / or DAT Tables (encrypted and SuperFiles allowed)
same as above but this time working from a Windows Folder where you will have placed the Tables to clone to SQL
in case a SuperFile is found the Tables inside it will be listed to allow you to SELECT all or any
d. Transfer Data from one DB to another (existing one)
this task will allow you to select a source DB – to select all or any tables then a destination DB and to
create all Profiles of data Transfers from source to destination
link all columns automatically for you
option to RUN the created profiles to Transfer the Data
if a Table is selected in source and does not exist in destination it will be logged as such and skipped
- This task is usefull also to only create the profiles then restore them one by one and change the MAPPINGS to best suit your needs
e. Transfer Data from a Windows FOLDER (multiple Table selection) to an existing SQL DB
same as above but this time working from a Windows Folder where you will have placed the Tables to transfer the data to existing SQL Tables
f. During a Data Transfer to an SQL Table perform an EXTERNAL TABLE LOOKUP on any column to use the retreived value
In mapping options this Lookup new FUNCTION allows you to select
another table in the same DB
a column from that Table to use as a lookup field
and to define a WHERE clause : link an external column with a destination one to perfom the lookup (upto FOUR columns can be used here)
these lookups can be repeated (one for each destination column) within the data transfer

PAUSE for all (music and drinks)

3. New DMC Runtime Engine to allow you to call and use DMC (special installer small footprint exe) from YOUR application using a “link” Table
Create a project in your copy of DMC and export it
Ship these files to your clients (place them where you wish)
The DMC RT template and TXA and TXD added to YOUR application will allow you to “talk” to the RT to dynamically change
TPS folders (they do not need to match between your dev machine)
ODBC connection components ( your dev loggin infos are not the same as your clients)
Updaye the “link” table DMC RT reads and parses before starting
Create for you the proper command line to run from your application

This new version-license of DMC Runtime Engine will allow you for example to
- Backup your end users SQL DB’s
- Update your end users TPS or SQL tables from ANY source
…..

4. Open answers and Real Life cases
I will show some real life implementaions of how DMC can be usefull to you in your work
- Parent Child with external lookups
- Merge several TPS together

5. Please bring your “problems” and or Tables and cases and I will try to help and solve help show …..

JP