DB Validate

[esgici]

Hi all

Damaged data files are nightmare of programmers

This little work try testing a .dbf file for validation.

No perfect nor claim to find all problems; simply try help as far as possible.

As always, all bug reports, critics and suggestions in any kind are welcome

Scren shoot of DB_Valid test

DB_ValidTest.jpg (39.68 KiB) Viewed 14962 times

DBV_Test.zip

Source files of DBV_Test

(12.41 KiB) Downloaded 653 times

Happy HMG'İng

PS: DB_Validate is a enhanced version of a lib routine with same name in LL_DBU.

[serge_girard]

Nice and usefull !

Thx, Serge

[Pablo César]

Damaged data files are nightmare of programmers

Yes, it is !
Would it be good to find a function that could reconstruct the structure of dbf and could take all data and replace in a corrected structure. As FixFile of old Norton Guide.

This little work try testing a .dbf file for validation.

In Stru.prg there is a function that recognize the type of dbf and check if memo file is missing, then it is created according the dbf type. But is creating a empty memo just to be able to open the dbf.

[esgici]

Damaged data files are nightmare of programmers

Yes, it is !
Would it be good to find a function that could reconstruct the structure of dbf and could take all data and replace in a corrected structure. As FixFile of old Norton Guide.

This little work try testing a .dbf file for validation.

In Stru.prg there is a function that recognize the type of dbf and check if memo file is missing, then it is created according the dbf type. But is creating a empty memo just to be able to open the dbf.

Hi Pablo

Thank to your interest

As name implied, mission of this function is only check and report validity of a .dbf file; not fix probable hazards.

As you noticed, there are clever programs, works to repair tables.

Viva HMG

[Pablo César]

As you noticed, there are clever programs, works to repair tables.

Yes, ia pity there is no solution does not pay ...