Page 1 of 1
DB Validate
Posted: Sat Aug 10, 2013 11:39 am
by 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 11546 times
- DBV_Test.zip
- Source files of DBV_Test
- (12.41 KiB) Downloaded 546 times
Happy HMG'İng
PS: DB_Validate is a enhanced version of a lib routine with same name in LL_DBU.
Re: DB Validate
Posted: Sat Aug 10, 2013 12:07 pm
by serge_girard
Nice and usefull !
Thx, Serge
DB Validate
Posted: Sat Aug 10, 2013 2:00 pm
by Pablo César
Esgici wrote: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.
Esgici wrote: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.
Re: DB Validate
Posted: Sat Aug 10, 2013 3:12 pm
by esgici
Pablo César wrote:Esgici wrote: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.
Esgici wrote: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
DB Validate
Posted: Sat Aug 10, 2013 3:16 pm
by Pablo César
esgici wrote:As you noticed, there are clever programs, works to repair tables.
Yes, ia pity there is no solution does not pay ...