HMGforum.com

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: https://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.

Gracias Roberto, como siempre un saludo grande

Many thanks, Roberto

With my best regards

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: https://hmgforum.com/viewtopic.php?p=27351#p27351

- MORE TESTING IS REQUIRED, ...

- PLEASE, TEST ...

Tested, no problem encountered

Everything is OK as mentioned.

Thanks again and Best regards

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: https://hmgforum.com/viewtopic.php?p=27351#p27351

It looks nice and appears to do the job. I'll test it.

Thanks!

esgici wrote:

- MORE TESTING IS REQUIRED, ...

- PLEASE, TEST ...

Tested, no problem encountered

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.

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: https://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.