Data Management Center

The DMC Software Recommendation Plan is a comprehensive program that allows existing registered DMC users to extend their protection period with FREE Software Maintenance.

All DMC licence holders with a valid current SMP can participate in the Software Recommendation Plan in 2 simple steps :

1. Recommend DMC to a friend.

2. Ask him to mention your NAME in the onsite “Message box” on the payment page when he order’s DMC.

You will receive a FREE extension period of SIX MONTHS and save from 60 USD to 75 USD

(this applies to NEW purchases of DMC Enterprise or Runtime Engine ONLY)

Extended Protection Period:

The protection period you win will be ADDED to your existing Software Maintenance Plan.

For each purchase of DMC done on your recommendation your protection period will be extended accordingly.

Each time you recommend DMC to a friend you lower your cost of Software Maintenance Plan.

We are pleased to introduce today a NEW way of purchasing DMC :
________________________________________
Software Maintenance Plan is a new “pricing policy” launched in January 2012.
Software Maintenance Plan is a subscription service added to your existing license and current SMP, whereas an upgrade license is a one off (allowing you to renew your expired old MP or SMP for 1 year).
Software Maintenance is bought on a yearly basis and once bought, customers will be protected for all upgrades on any release, as well as enjoying our priority email support.
Upgrade License is for customers who did not subscribe to our software maintenance plan or who let their old MP or SMP expire but want to upgrade their license to the latest release and also enjoy a 1year SMP.
The upgrade license price is 50% of the new license price, whereas for Software Maintenance Plan it is as low as 25% of the license price.
________________________________________

To renew your software maintenance subscription, please login to our Customer Center and click on “Renewal” under the Product Summary section.
To see all these new prices please visit this page. As a comparison with the old prices : the Enterprise level 1 year renewal is lowered by 20 % (saving you nearly 30$) and the Runtime Engine one is at the same price (unchanged since over 18 months)!
Please kindly be reminded that renewal of Software Maintenance subscription cannot be done after the expiry date. **
** : an “extension delay” of 15 days is allowed onsite after your actual expiration date. This provides a bit of flexibility where a person might be on vacation or away when the renewal is due.
What’s included in the Maintenance Plan?
• All Major/Minor Software Release and bug fix releases that are released during the protection period.
• Priority Email Technical Support (support@dmc-fr.com): DMC’s professionals will respond within 1-2 business days during APAC business hours (Monday – Friday, 9am – 7pm GMT+1).
• Live Chat Skype Support : DMC’s professionals are present to help you throughout the APAC business hours (Monday – Friday, 9am – 7pm GMT+1).
• Remote Desktop connection to your machine (Team Viewer) (limited to 30 minutes) to help you sort out any problem you may have with DMC during the APAC business hours (Monday – Friday, 9am – 7pm GMT+1).
Is the subscription to Maintenance Plan mandatory?
Subscription to our software maintenance is not mandatory. However, we do ask for your consideration as subscribing to the Software Maintenance Plan not only allows you to receive priority email and skype support or Remote Desktop connection support, but also help you saving your cost on acquiring the latest version of DMC. An Upgrade License of DMC costs 50% of the product price, while price of Software Maintenance is as low as 25% of the product price, allowing you to get free major/minor software release without any additional cost.
For more information about DMC Software Maintenance Plan and FAQs, please visit our DMC Software Maintenance Plan page.
Thank you for choosing DMC!

For all who are “into” clarion7/8 :

I had to change my motherboard as it was starting to show signs of weakness (LAN connectors)

I had a supermicro dual opteron dual cores with 2×2.8 ghz. cpu’s and 16 gb ram ddr2 at 667.

I changed it for an asus motherboard with one Intel cpu 4×3.4 ghz. and again 16 gb ram but ddr3 at 1333.

(same HD “chain with the areca controller card and my 12 raptors in raid6)

1. Opening my app takes LESS time and is quasi instantanuous
2. Reading AND storing ABC files (whatever is done during this time) is down to UNDER 4 seconds when it took around 11 seconds on the old motherboard.
3. Compiling the entire application takes roughly HALF as long as it did on the old motherboard

This confirms what I have always thought and said : clarion 7/8 is VERY “ressource” demanding, so the faster your
CPU
RAM
are the faster you will be able to work

For me now it becomes more of a pleasure to use clarion8

EVEN code completion and parsing can NOW be turned ON

My main procedure is still slightly noticable the first time I enter it whil it builds the PWEE but it is then absolutely “usable” whereas it was NOT with the old motherboard (and RAM)

My conclusion is simple : if you do not have the latest and fastest RAM and CPU ….. well I lived hapily with it for two years

In DMC SQL settings select and define your destination folder
(this is where DMC will copy the necessary files for you to use as a “new” folder for your SQL application)

Both DCT (created from generated DCTX) and generated TXA’s) should be in the same folder (your “destination” folder) and are copied there for you by DMC

Do not create an empty app to import the generated TXA

1. From Start Page click on “New solution”

2. Select  Clarion for Windows

3. Select “Application from TXA”

4. Location is the folder containing the DCT and the generated TXA

5. Name is what you want it to be

6. Do NOT check the “Auto create project subdir”

7. When prompted for a TXA select the DMC generated one

Here is a small template  to reposition all forms centered wherever the user moves the parent browse

! ——————————————————————– !
#! Template Position Form
#TEMPLATE (CGFPositionForm, ‘Template to Center a Form Window’),FAMILY(‘ABC’)
! ——————————————————————– !
#EXTENSION (VariablesCGFPositionForm, ‘Position your Forms (Procedure)’)
#DECLARE(%CGFSetChildPos)
#Boxed,Section,At(0,5,190,15)
#Display(‘Template CGF Position a Form (centered)’),at(50,0)
#Display(‘Copyright © 2011 by CGF’),at(50,10)
#EndBoxed

! ——————————————————————– !
#! Variables CGF Window ou Browse
! ——————————————————————– !
#TAB (‘ Window-Browse-Form ‘),WHERE(UPPER(%ProcedureTemplate)=’WINDOW’ OR UPPER(%ProcedureTemplate)=’BROWSE’ OR UPPER(%ProcedureTemplate)=’FORM’)
#Boxed(‘ Position Window’),Section
#Prompt(‘Set Form Position (centered to Browse) ‘,CHECK),%CGFSetChildPos,DEFAULT(%False),AT(10,4)
#EndBoxed
#ENDTAB

! ————————————————————————————————- !
! Position the CHILD FORM
! ————————————————————————————————- !
#AT(%DataSection)
#IF(%CGFStoreParentPos OR %CGFSetChildPos)
! CGF Parent/Child Windows Positioning
PosParent_X       LONG
PosParent_Y       LONG
PosParent_W       LONG
PosParent_H       LONG
Child_H           LONG
Child_W           LONG
#ENDIF
#ENDAT
#! Init – 2501
#AT(%WindowManagerMethodCodeSection,’Init’,'(),BYTE’),Priority(2501)
#IF(%CGFStoreParentPos)
! CGF Store Parent window Position
GETPOSITION(0,PosParent_X,PosParent_Y,PosParent_W,PosParent_H)
#ENDIF
#ENDAT
#! Init – 9001
#AT(%WindowManagerMethodCodeSection,’Init’,'(),BYTE’),Priority(9001)
#IF(%CGFSetChildPos)
! CGF RePosition the Window from the Parent’s position
pix# = 0{PROP:Pixels}
0{PROP:Pixels} = False
Child_H = 0{PROP:Height}
Child_W = 0{PROP:Width}
SETPOSITION(0,PosParent_X + ((PosParent_W / 2) – (Child_W / 2))  , PosParent_Y + ((PosParent_H / 2) – (Child_H / 2)) , , )
0{PROP:Pixels} = pix#
#ENDIF
#ENDAT

enjoy ….

We are pleased to announce the availability of Version 2.4.2.1469.

This release is available, free of charge, to all DMC customers who have an active DMC maintenance and support plan subscription (and to all evaluation level users).

The most robust version to date, Version 2.4.2 includes many new and enhanced functionality and some very important bug fixes.

We strongly recommend that all customers upgrade to the latest version of DMC 2.4.2.1469 as soon as possible to maintain the highest level of support, performance and reliability.

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

We have introduced a NEW renewal option : purchase a _LIFETIME renewal_ and save money see this by clicking here ( “http://www.dmc-fr.com/boutique_en.php” )

NEW RT demo applications and RT deploy on end user machines for the Runtime Engine are available by clicking here ( “http://www.dmc-fr.com/download_en.php” )
________________________________________________________________________

_Version 2.4.2.1469_ details :

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

_______________________________________________________________________

Visit this page ( “http://www.dmc-fr.com/howtodo_port_sql.php” ) to see more information’s and a flow chart of the work done in DMC while Porting to SQL

DMC SQL Discovery Pack will let us HELP you with YOUR application while porting it to SQL (owning a DMC License is NOT required for this) is now available on site in the Shop

(you can also purchase this “Pack” if you need us to HELP you in any SQL related porting issues you may have)

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)

________________________________________________________________________

I have found out that MsSQL server when a schema name is a KEYWORD will not allow us to access it without special coding :
(example ‘tran’ is a KEYWORD and such a schema must be accessed in a special way)

If you want to CREATE or DROP or SELECT in any table in such a schema then use this type of code :

CREATE [schema].[tablename]

DROP [schema].[tablename]

SELECT * from [schema].[tablename]

but when you are accessing the tables for inputs or even a selct you can also use this type of code :

SELECT * from “schema”.tablename

so depending on what you will be doing …. pick your best friend

I just wanted to let you all know that from the current beta version 2.3.4.1324 DMC will ALSO help you in Porting to SQL your compound multi columned AUTOINC KEYS

Imagine you have a UNIQUE AUTOINC KEY on 3 Columns :
CustNumber
OrderNumber
LineNumber

You expect and need to have the LineNimber Column autoincrememnted PER OrderNumber PER CustNumber

Open your TPS DCT and select that KEY

ADD an OPTION and use one of DMC’s TOKENS : DMCSkipIdentity

Export to DCTX and parse in DMC

DMC seing this token will NOT add the IDENTITY default in the Column and when generating a new DCTX for you will ADD BACK the AUTOINC attribute in the ported KEY

This means that your application (clarion side) will generate an autoinced LineNumber ID when you insert a new record and the SQL server will accept this value as it is UNIQUE (the combination of the 3 columns)

Problem solved!!

PS: The 2.3.4 version will soon be released to public

Because of an unexpected personal emergency situation in my family I need to raise cash very quickly.

This is why I have decided to setup a DMC Flash Sale and as an incentive for you ALL I will offer unbeleivable discounts :

From today 12/02/2011      till sunday   20/02/2011 -> 50% OFF public price
From monday 21/02/2011 till sunday   26/02/2011 -> 25% OFF public price
From monday 27/02/2011 till tuesday 28/02/2011 -> 10% OFF public price
(discounts end at midnight GMT)

Please visit this page to see the public prices, start dividing … and click on the Buy it now button!

These discounts apply to all purchases – updates or renewals.

Wether you need DMC today or only in the coming months, today is the day to purchase it!
_______________________________________________________________________

Examples (depending on the excange rate applicable by SWREG) :

You have never purchased DMC yet -> get a Full Runtime Engine (allows you to deploy on your end users machines [upto 2500 machines]) license for as little as ~265 USD (save 265 USD)

You have never purchased DMC yet -> get a Full Enterprise license for as little as ~195 USD (save 195 USD)

You received a FREE Viewer license -> upgrade to Full Enterprise license for as little as ~160 USD (save 160 USD)

You have a ellapsed or current Enterprise license -> renew for a Full YEAR for as little as ~77 USD (save 77 USD)

You would like me to help you test DMC’s Port to SQL feature on your** application -> get the SQL Discovery Pack (two hours with me connected to your machine) for as little as ~90 USD (save 90 USD)

If your subscription plan is current -> the end date will be applied to existing end date + 365 days
_______________________________________________________________________

Use this coupon code on the SWREG payment portal to benfit from these discounts : DMC-45K2D46627

The prices onsite do NOT reflect the discounts – they are applied ONLY when you purchase WITH this coupon code!
_______________________________________________________________________

Wether you need DMC today or only in the coming months, today is the day to purchase DMC!

We are in the process of finalizing the new version 2.3.3

Here is a list of added features and changes :

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 to workaround a clarion 6 -> clarion 7 DCT bug where a PICTURE(05) line can be imported
Support in TXD parser from c7 back to c6 to workaround a clarion 6 -> clarion 7 DCT bug where an OPTION and RADIOS are used in REPORTCONTROL but the OPTION line is missing and can be imported
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 -  visible ONLY when you have selected a PROFILE – and which allows you to RESTORE this SELECTED Profile (mappings etc) exactly like when you use a “Restore profile” task
Corrected a bug in TXA parsing when using SQL 2008 and DATE or TIME columns

Stay tuned for the release date