DBC

Issues and Discussions related to Harbour

Moderator: Rathinagiri

Post Reply
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

DBC

Post by Roberto Lopez »

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.
Attachments
dbch_39_fixed.7z
(6.07 KiB) Downloaded 284 times
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
danielmaximiliano
Posts: 2611
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: DBC

Post by danielmaximiliano »

Gracias Roberto, como siempre un saludo grande
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: DBC

Post by esgici »

Many thanks, Roberto

With my best regards :D
Viva INTERNATIONAL HMG :D
User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil

DBC

Post by Pablo César »

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).
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
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: DBC

Post by esgici »

- MORE TESTING IS REQUIRED, ...

- PLEASE, TEST ...
Tested, no problem encountered :arrow:

Everything is OK as mentioned.

Thanks again and Best regards :)
Viva INTERNATIONAL HMG :D
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: DBC

Post by Roberto Lopez »

Pablo César wrote:
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).
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
It looks nice and appears to do the job. I'll test it.

Thanks!
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: DBC

Post by Roberto Lopez »

esgici wrote:
- MORE TESTING IS REQUIRED, ...

- PLEASE, TEST ...
Tested, no problem encountered :arrow:

Everything is OK as mentioned.

Thanks again and Best regards :)
Thanks for the test.

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)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: DBC

Post by Roberto Lopez »

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
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).

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)
Post Reply