DataCheck

FAQ
Purchase
Download
 DataCheck scans your data files looking for inconsistancies and damage. It is the best detection tool available for 4D structure files, alerting you to more potential issues than any other tool available. It can also solve problems that no other tool can solve, and has been called upon to save several businesses from disaster.

DataCheck is best used to as a maintenance tool to validate your data file on a periodic basis. DataCheck can catch problems before any other tool sees them, which gives you the ability to be ahead of the game, scheduling for downtime instead of downtime at 9am on monday morning.

Compatibility

 DataCheck runs on all versions of 4D from version 3.5 to 2004.5.
That's over 10 years of revisions from 4D that can be parsed by the modern version of DataCheck.

Data Validation

 DataCheck scans the data looking for "oddities"
For example, dates that are wildly out of range, or Numbers that don't actually exist! (NANs)

Even if you have robust input checking schemes, sometimes data can enter your database via imports or ui usage that was not intended by the designers.

Index checking

 DataCheck has the most powerful index checking routines available for 4D.

Each record's field is verified to be in an index and each index's entry is verified to be in a reocrd. This bi-directional verification ensures that your QUERY() commands do the right thing in 4D.
If an index is damaged, you also have several options on deleting and rebuilding it, up to and including the "force drop all" which is a very quick, very powerful index recovery tool in DataCheck.

Data Perusal

 You can look at your data record-by-record. You can also look at the allocation blocks across your disk, to see if the data is getting fragmented. You can delete and undelete records.

Sequence Numbers

 Only DataCheck gives you a way to modify the sequence numbers in your database. When a table sequence number goes haywire, DataCheck is the only way to diagnose and fix it.

DataCheck Runtime

 A runtime version of DataCheck can be purchased which allows you to send DataCheck to a client without worrying that they will fiddle with the options and accidentally do damage to their database.

DataCheck Runtime can only run using special command files you give your client. You can build one that "drops all indexes" for example. Or "scan for gremlins". That way, when needed, you can ask the client to run a particular action on the data base. DataCheck Runtime is priced in a way that makes it very easy to pass the cost along to the customer without breaking the bank.