DBU

DBU

Postby Otto » Wed Jun 16, 2021 8:30 am

Dear friends,
May I ask you today which "DBU" you are using.
I currently don't have a version that works well.
I edit the data with one dBase editor, but need a different editor to change tables. If there are new field types in the DBF, then another editor is required.
Also, none of my dBase editors are still being maintained.
Maybe we could come to an agreement on an open source DBU here.
What do you all mean?
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6005
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBU

Postby vilian » Wed Jun 16, 2021 10:54 am

Hi Otto,
When i worked with DBF files I used to use ARC32 (Advantage Data Architect 32) ;)
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 920
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: DBU

Postby Otto » Wed Jun 16, 2021 11:15 am

Hello Vilian,
Thanky you.

I just got this tip in the HARBOUR FB and am currently testing with this EDITOR.
The editor looks professional.
What I haven't found yet is.

- User interface for end user and admin.

- How to set relations between to dbf files.

- What I always need is sorting when I click in the column header.

- Incremental search when I start typing.

Then the statistics function, i.e. all numeric data fields are automatically added up
-
and of course search and replace.

Can you please show me where I can find these functions?

For my business, the editor is one of the most important things.
And I have a mix of own made, Fivetech and some editors of our friends.

BTW what do you use for SQL?
Maybe you have something more comfortable as phpmyadmin?

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6005
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBU

Postby vilian » Wed Jun 16, 2021 11:28 am

Otto,
If you open a table that has a index file (CDX), you can do almost everything you want in this part of the screen:

Image

You can also execute SQL expressions through this menu:

Image

I Used to do REPLACE using SQL expressions
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 920
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: DBU

Postby Otto » Wed Jun 16, 2021 1:28 pm

Hello Vilian,

It is a pity.
The ADS dBase editor is professional, but exactly the functions that we need all the time don't exist there.
Especially now, when we use a lot of small DBF files with mod harbor and these without an index, we need a good tool. For example, I have a food dictionary here.
The web server is directly on the customer server.

Now a receptionist has to update the dishes. He uses the editor from our friend Enrico.
Showcase
control if there are all translations
He is noticed that "Wiener Schnitzel" is missing in a language.
Search Wiener Schnitzel
Then make global control for more missing translations.
Click on header, go to the top, and you have all you need.
This editor is handy like a text editor. But for statistics I need another one.
Although we have all the functions, we need.


LG Otto

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6005
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBU

Postby Antonio Linares » Wed Jun 16, 2021 5:55 pm

FWH\samples\fivedbu.prg

Full source code, customize it the way you may need it. What else ? :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 41314
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: DBU

Postby Otto » Wed Jun 16, 2021 6:57 pm

Dear Antonio,
My compliments,
I am sorry I had an older copy. I see it is now a very complete product.
What I don't see is the statistical part of the old WDBU.
Thank you.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6005
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBU

Postby Otto » Wed Jun 16, 2021 8:57 pm

Dear Mr. Rao,
Would you be so kind to insert your DBF to HTML function into DBU export?
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6005
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBU

Postby TimStone » Thu Jun 17, 2021 6:09 pm

I modified the DBU Antoinio mentioned several years ago and have had it as part of my application ever since. I even wrote documentation for it in the manual. My clients have learned to use it.

With that said, I plan to make some modifications because I find it performs very slowly, especially in a network. I just haven't had time to do it so far. It provides everything that is OK for an end user to access.
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2904
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: DBU

Postby Otto » Thu Jun 17, 2021 6:53 pm

Hello Tim,
Yes, that's what I meant by admin and end user mode.
Customers need a simple editor.

FIVEDBU from the samples is very complete now, and we should all start using it.

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6005
Joined: Fri Oct 07, 2005 7:07 pm

Re: DBU

Postby Uwe.Diemer » Fri Jun 18, 2021 3:12 pm

User avatar
Uwe.Diemer
 
Posts: 93
Joined: Mon Aug 09, 2010 11:00 am

Re: DBU

Postby Marc Venken » Sun Jun 20, 2021 10:34 pm

I could also put a next "DBU like" program in the forum, but it seems that many of us are using some 3-party software and that is somewhat strange, since FWH IS database management.

I agree that FIVEDBU could become the best option for most database handling. I also use Fivedbu and Enrico's dbu.

I use it allmost only now for updating dbf structures, for viewing mostly a quick Xbrowser with some settings..
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1343
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: DBU

Postby Silvio.Falconi » Wed Jun 23, 2021 11:43 am

Otto wrote:Hello Tim,
Yes, that's what I meant by admin and end user mode.
Customers need a simple editor.

FIVEDBU from the samples is very complete now, and we should all start using it.

Best regards,
Otto


I use EmagDbu from many years
and fivedbu sometimes
where is the last release of fivedbu ?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 6772
Joined: Thu Oct 18, 2012 7:17 pm

Re: DBU

Postby Silvio.Falconi » Wed Jun 23, 2021 11:46 am

Antonio Linares wrote:FWH\samples\fivedbu.prg

Full source code, customize it the way you may need it. What else ? :-)


is it the last release ?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 6772
Joined: Thu Oct 18, 2012 7:17 pm

Re: DBU

Postby Antonio Linares » Thu Jun 24, 2021 7:01 am

yes
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 41314
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Next

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 87 guests