NoError47 Template 6.1

Click to Start/Stop
Introduction
NoError47 File Converter Template for 5~5.5~6.3 ABC/Legacy. White box Template to automatically and amazingly fast get rid of nasty Error 47.This template works similar to the built in Dictionary file converter and uses Standard Clarion program TPSFix.EXE engine to automatically convert old data files into new ones. All you have to do - add extension template to your executable main frame and optionally change these few settings --->
And NoError47 Template will do the rest with amazing speed. So conversion which usually takes 10 hours now can be done for just quarter of an hour. Get Demo.
NoError47 Template is a simple File Converter  for Clarion 5~5.5~6 ABC/Legacy.
As far as we are concerned it is a white box template. On the other hand it uses
Clarion TPSFix.EXE file recovery utility which is a black box program for all of us
While fighting a data file corruption we have accidentally discovered that this tool
can be used not only for fixing corrupted data filed, but also for conversion of changed
data files and it does it with amazing speed. So this tool is especially useful
where conversion speed does matter. For instance we are using this converter for one of our
clients who runs an application 24 hours a day and has few rather big TPS files
some 100 Mb each. Not until recently we had to completely paralyse their work for
10 hours or so just to add one key into one of those files. Now with NoErro47 the same
procedure takes 15-20 minutes. And they do appreciate it...
Download NoError47 demo program to see it yourself
Main advantages:
  • Template Converts files with the 'speed of light'
  • It has not got any secrets - because it is transparent white box template
  • It has no overheads so it can be easily added and removed from an application
  • It can be used either in fully automatic mode or launched from an
    application by users
  • It works in Clarion 5~5.5~6 ABC/Legacy
  • It does not need or do any changes to either Clarion native
    or 3d party templates. It's our taboo!
  • It has very few optional  settings (see picture above) so no learning
    is involved
  • It does not need changing standard Clarion templates
  • Conversion will optimize data files and make them 20-30% smaller
Some Restrictions:
  • Template can be used only with TPS files (no prehistoric *.dat)
  • New fields may only be appended to the list of a file fields
  • TPSFix.EXE does not clean just created fields, but it can be done from embeds
  • Only last field/fields in the list of a file fields can be deleted
As seen from those restrictions, NoError47 Template appears to be useful  in well established
databases, where you can go just with minor dictionary changes. To the best of our knowledge
there are no restrictions for key changes so you can do absolutely everything you
want to them. As to the file fields - some programming discipline is required
Installation
Run the installation wizard. It will guide you through a few simple steps. That is it.
IMPORTANT: If you are using Clarion 5 or 5.5, after selecting Clarion5 or C55 directory wizard
will offer you to install it into C:\Clarion5\Clarion6 or C:\C55\Clarion6 directory respectively.
So do not forget to get rid of last \Clarion6. But even if you do - it is not a problem.
Just uninstall template and run installation once again.
To start using template you have to manually register it.
Here is instruction: Open Clarion (no application must be open). 
Go to menu Setup -> Template Registry ->Register. Select new template
NoErr47.tpl and then hit Open button
View animated reminder on how to do that - Registering Template
(built with our JAVA Animated Help Builder).

Using Template

One Executable Applications
1. Open Global -> File Control (second tab) of your application and make sure that
Generate all file declarations checkbox is checked
2. Open the mainframe procedure property and insert NoError47 extension template
Make sure that the mainframe procedure has not got any
files in the file schematic. That is basically it.
3. If for any reasons you do not want some files to be processed
(for instance you may have data files in your dictionary other then TOPSPEED ones)
find and Insert them in the Skip Files list box (see the picture above)
By default template will backup all files in TPSFix.EXE manner (FileName.TP1, FileName.TP2 etc.)
To suspend this behaviour - tick the checkbox Backup Data Files
Multi-DLL Applications
You should follow the same 3 steps to install NoErro47 template. The only difference -
All file declarations should be generated in your main DLL which exports all file declarations,
template globals and ABC stuff (for ABC). The NoError47 template still has to be installed
in the Mainframe of your executable only.
IMPORTANT: NoError47 does not keep history of your changes so it works similar to
the built-in Dictionary file converter. That is why to successfully use it you should
follow these few simple rules.
You can:
  1. change, insert, delete any keys in your files
  2. append new fields in the file field list
  3. delete last field or last few fields
  4. rename fields
You can not:
  1. insert fields in or delete them from the middle of the field list
  2. change data type of existing fields
Standalone NoError47 Converter
If you want your program users to be able to launch conversion themselves, you have to
create new EXE using the same dictionary (say you call it yourconv.EXE and you run your
main application from C:\YourWorkDir). The steps are absolutely the same as for
building One Executable Applications. After this you can call yourconv.EXE either from
outside of your program or from any button or menu item within it. The only thing to bear
in mind - if your data are kept in any other directory than your working directory you have
to pass its name as the first command line parameter. The syntax is simple:

RUN('yourconv.EXE C:\YourWorkDir\YourDataDir\')
Have a look at the example we are shipping with this template for details
Examples
We installed an example into your Clarion*/Examples/VhNe47/Demo
Error47ed files are stored in the subdirectory /Orig so you can compare them with
converted files say with TopScan program
The TPS data files for the demo were generated with the Clarion Data modeller
So content of all those fields is meaningless
Beautification
You can easily customize those two windows which pop up before and after file conversion
without changing template. We put them in the TRN file noe47win.trn which you can find
in your Clarion*/Libsrc directory. To simplify that we would suggest you to
open this file from Clarion. In this case you will be able to edit those windows visually.
Just put cursor anywhere in the window definition and hit the magic Format button.
Shipping
You have to ship with your application latest version of TPSFix.EXE program
which for your convenience we have included into NoError47 Installation program
One million dollar question is which TPSFix.EXE to use. Some of them are pretty
buggy and just do not do the job. The best one is from Clarion6 Gold. So if you
own C6 this is the one. As it is an EXE, you can use it with all your applications
C5, C55, C6. If you use C55 we would recommend you the version
we use in template example - of 7 Aug 2001, but not of 11 May 2002.
As to C5, it's own TPSFix.EXE cannot be used because it was pretty
primitive those days. So to use this template with C5 applications you have to
own C55 or C6 to borrow TPSFix.EXE from any of those.

Copyright (C) 2002 Vivid Help Systems Pty Ltd