DBC
Moderator: Rathinagiri
- Roberto Lopez
- HMG Founder
- Posts: 4009
- Joined: Wed Jul 30, 2008 6:43 pm
DBC
As I've posted already, DBC has been my primary dbf files manager from its first version (I'm a hardcore fan )
DBC is very simple and powerful. It is a great work of Alexander Kresin (author of HWGUI and one of the Harbour compiler main developers).
Some time ago, I've noted that in one of my apps, deleted records were recalled without no aparent reason. After research a little, I've found that this happened only with tables that were modified (with added new fields). Then, I've realized that the problem were related with DBC. In this process, I've found some other bugs too.
Please, consider these fixes temporary, until a new DBC version be released by its original author.
These are the bugs fixed
1. Changing fieldnames only when changing structure, made DBC crash.
2. Deleted records were recalled when changing structure.
3. When new fields added, if name, type or size were empty, DBC crashed. Now, user is warned and operation is cancelled.
- BE AWARE THAT WHEN CHANGING FIELD NAMES, FIELD CONTENT WILL BE LOST. THIS APPEARS TO BE A BEHAVIOR BY DESIGN.
- MORE TESTING IS REQUIRED, SO, COULD BE MORE PROBLEMS YET TO BE FOUND ** USE AT YOUR OWN RISK **
- PLEASE, TEST AND REPORT ANY OTHER PROBLEM YOU FOUND.
How to build:
1. Download DBC (Console version) from Alexander Kresin site: http://www.kresin.ru/en/dbc.html ('Download dbch_src.zip' link at the bottom of the page).
2. Replace 'modistru.prg' file with the one provided with this package
3. Build it the way you prefer (hbmk2 dbch.hbp is the easiest one).
Roberto.
DBC is very simple and powerful. It is a great work of Alexander Kresin (author of HWGUI and one of the Harbour compiler main developers).
Some time ago, I've noted that in one of my apps, deleted records were recalled without no aparent reason. After research a little, I've found that this happened only with tables that were modified (with added new fields). Then, I've realized that the problem were related with DBC. In this process, I've found some other bugs too.
Please, consider these fixes temporary, until a new DBC version be released by its original author.
These are the bugs fixed
1. Changing fieldnames only when changing structure, made DBC crash.
2. Deleted records were recalled when changing structure.
3. When new fields added, if name, type or size were empty, DBC crashed. Now, user is warned and operation is cancelled.
- BE AWARE THAT WHEN CHANGING FIELD NAMES, FIELD CONTENT WILL BE LOST. THIS APPEARS TO BE A BEHAVIOR BY DESIGN.
- MORE TESTING IS REQUIRED, SO, COULD BE MORE PROBLEMS YET TO BE FOUND ** USE AT YOUR OWN RISK **
- PLEASE, TEST AND REPORT ANY OTHER PROBLEM YOU FOUND.
How to build:
1. Download DBC (Console version) from Alexander Kresin site: http://www.kresin.ru/en/dbc.html ('Download dbch_src.zip' link at the bottom of the page).
2. Replace 'modistru.prg' file with the one provided with this package
3. Build it the way you prefer (hbmk2 dbch.hbp is the easiest one).
Roberto.
- Attachments
-
- dbch_39_fixed.7z
- (6.07 KiB) Downloaded 292 times
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
- danielmaximiliano
- Posts: 2618
- Joined: Fri Apr 09, 2010 4:53 pm
- Location: Argentina
- Contact:
Re: DBC
Gracias Roberto, como siempre un saludo grande
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
DBC
Hi Roberto, I do not know if you had already the chance to see STRU app works. Even deleted records, when modifying dbf it keeps as it is. It works in GUI and in line command too.Roberto Lopez wrote:Some time ago, I've noted that in one of my apps, deleted records were recalled without no aparent reason. After research a little, I've found that this happened only with tables that were modified (with added new fields).
You can download from this: http://hmgforum.com/viewtopic.php?p=27351#p27351
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
- Roberto Lopez
- HMG Founder
- Posts: 4009
- Joined: Wed Jul 30, 2008 6:43 pm
Re: DBC
It looks nice and appears to do the job. I'll test it.Pablo César wrote:Hi Roberto, I do not know if you had already the chance to see STRU app works. Even deleted records, when modifying dbf it keeps as it is. It works in GUI and in line command too.Roberto Lopez wrote:Some time ago, I've noted that in one of my apps, deleted records were recalled without no aparent reason. After research a little, I've found that this happened only with tables that were modified (with added new fields).
You can download from this: http://hmgforum.com/viewtopic.php?p=27351#p27351
Thanks!
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
- Roberto Lopez
- HMG Founder
- Posts: 4009
- Joined: Wed Jul 30, 2008 6:43 pm
Re: DBC
Thanks for the test.esgici wrote:Tested, no problem encountered- MORE TESTING IS REQUIRED, ...
- PLEASE, TEST ...
Everything is OK as mentioned.
Thanks again and Best regards
I usually works with big tables (100000+ records) with many fields.
Many dbf utilities that works well with small tables, simply crash, become terribly slow or mess with data with big tables.
Despite the problems described (and fixed) DBC is extremely fast and reliable with big tables and has all I need with working in tables maintenance.
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
- Roberto Lopez
- HMG Founder
- Posts: 4009
- Joined: Wed Jul 30, 2008 6:43 pm
Re: DBC
I'm sorry, but in my tests 'stru' does not keep delete marks after adding, removing or changing fields data type (I've repeated the test 3 times before report to you).Pablo César wrote:Hi Roberto, I do not know if you had already the chance to see STRU app works. Even deleted records, when modifying dbf it keeps as it is. It works in GUI and in line command too.
You can download from this: http://hmgforum.com/viewtopic.php?p=27351#p27351
Another problem I've found, is that, if the dbf file to process has a name with only one character (ie: 'a.dbf') stru will crash.
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)