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
Happy HMG'İng
PS: DB_Validate is a enhanced version of a lib routine with same name in LL_DBU.
DB Validate
Moderator: Rathinagiri
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
DB Validate
Viva INTERNATIONAL HMG
- serge_girard
- Posts: 3169
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
DB Validate
Yes, it is !Esgici wrote:Damaged data files are nightmare of programmers
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.
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 wrote:This little work try testing a .dbf file for validation.
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: DB Validate
Hi PabloPablo César wrote:Yes, it is !Esgici wrote:Damaged data files are nightmare of programmers
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.
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 wrote:This little work try testing a .dbf file for validation.
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
Viva INTERNATIONAL HMG
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
DB Validate
Yes, ia pity there is no solution does not pay ...esgici wrote:As you noticed, there are clever programs, works to repair tables.
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein