DBU on Harbour

[jo...@zeelandnet.nl]

Anyone got a working source to compile under Harbour ?
I have some versions but will not compile due to missing external programs.
Is there one around what includes all and can be compiled (under Ubuntu linux ?)

Johan

[jo...@zeelandnet.nl]

Note, its for Linux console I am searching for.

[elch]

Johan,

me already again :-)

? you have a Clipper ?

then .. in the directory: extras/dbu

you will find a readme.txt how to build the original Clipper dbu from source for Linux.

I confirm it works well, sure a console app ...

You may - perhaps - get later some trouble with lowercase filenames for i.e. dbf/dbt files as Linux is case sensitive.

Then convert your data files to lowercase. For this are many possibilities like f.e. convmv ...

Regards

Rolf

[jo...@zeelandnet.nl]

I found a spanish version, but it wont compile, missing something.
But, i need it under linux (ubuntu-console)

I dont have clipper, can you send me something ?

On Friday, May 3, 2013 9:30:31 PM UTC+2, jo...@zeelandnet.nl wrote:

[Antonio Linares]

Here you have a free DBU for Windows that includes full source code and also provides ADO support:

https://code.google.com/p/fivewin-contributions/downloads/list   FiveDBU

developed with Harbour and FiveWin (FWH)

Antonio

[Maurício Ventura Faria]

Hi Antonio, great !
Antonio, what about a multi language ready version ? I translated it to Portuguese but doing it again and again for each version is a dumb work...
While setting a filter, in the filter check function, an invalid expression generates an unrecoverable error at GENBLOCK, before the TRY...
Corrected code :

//----------------------------------------------------------------------------//

function CheckExpression( cExpression )

   local bCode, lResult := .F., oError

   TRY
      bCode := GENBLOCK( cExpression )
      Eval( bCode )
      lResult = .T.
   CATCH oError
      MsgAlert( oError:Description + If( ! Empty( oError:Operation ),;
                CRLF + oError:Operation, "" ) + CRLF + ArgsList( oError ),;
                "Expression error" )
   END

return lResult
 


[[]] Maurício Ventura Faria

--
--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-user...@googlegroups.com
Web: http://groups.google.com/group/harbour-users
 
---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Qatan]

Le samedi 4 mai 2013 12:08:49 UTC+2, Antonio Linares a écrit :

Here you have a free DBU for Windows that includes full source code and also provides ADO support:

https://code.google.com/p/fivewin-contributions/downloads/list   FiveDBU

developed with Harbour and FiveWin (FWH)

Antonio

 

 

Hello Antonio,

 

Nice program, thanks.

I tried to click on "Report" but got this message: "prev32.dll not found"

 

Thanks for your help.

 

Qatan

 

[Antonio Linares]

Qatan,

You can download prev32.dll from here:
https://code.google.com/p/fivewin-contributions/downloads/detail?name=prev32.dll

Also there is an enhanced FiveDBU version: (full source code included)
https://code.google.com/p/fivewin-contributions/downloads/detail?name=fivedbu_20130508.zip

thanks

Antonio

2013/5/8 Qatan <wanst...@gmail.com>:

> --
> --
> You received this message because you are subscribed to the Google
> Groups "Harbour Users" group.
> Unsubscribe: harbour-user...@googlegroups.com
> Web: http://groups.google.com/group/harbour-users
>
> ---

> You received this message because you are subscribed to a topic in the

> Google Groups "Harbour Users" group.

> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/harbour-users/pTx5POBJ1hM/unsubscribe?hl=en-US.
> To unsubscribe from this group and all its topics, send an email to

> harbour-user...@googlegroups.com.
>
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
Antonio Linares
www.fivetechsoft.com

[Antonio Linares]

Qatan,

Here you have a video tutorial for managing FiveDBU + ADO :-)

Please select HD (high definition) from facebook, or it looks horrible:
http://forums.fivetechsupport.com/viewtopic.php?p=144358#p144358

Antonio

2013/5/8 Antonio Linares <alin...@fivetechsoft.com>:

--
Antonio Linares
www.fivetechsoft.com

[Qatan]

Hello Antoni

 

Now it is working fine.

Thanks for your help and for this nice utility.

 

Qatan 

[Gmail]

>Here you have a video tutorial for managing FiveDBU + ADO :-)
>
>Please select HD (high definition) from facebook, or it looks horrible:
>http://forums.fivetechsupport.com/viewtopic.php?p=144358#p144358
>
>Antonio

Hello Antonio,

Very nice, thanks for your help.

Qatan

[elch]

hi,

i'm astonished that nobody miss the possibility of opening existing indexes files (f.e. dbfntx).

Editing data without these indexes will lead to defekt index files.

So i must be the blind one and only didn't find the place where to do.

Please, how to open existing index ?

Regards

Rolf

[Gmail]

Here it opens fine, automatically and I can select which index I want to use to browse data.

It is the 7th icon on the browsing top bar.

Well, I use DBFCDX...

 

Qatan

[elch]

hi Qatan,

thanks for response !

My question was after a full hour of search and try ( i got today too much spare time ;) - so i surely stumbled over that icon ...

I am somehow able to create ONE new dbfntx index, but this seem not be opened automatically when opening the dbf again. So on every open i have to create it ...

But the most ultimate problem:

the national chars are wrong displayed, and so the resulting index on a text field is scrap.

I counter-checked that with an 'original' (Harbour) dbu in my language setting.

Regards

Rolf

[Antonio Linares]

Rolf,

I am going to review those issues, thanks for your feedback

Antonio

2013/5/8 elch <spamd...@iesy.net>:

[SD]

Thanks for the info. and congratulations for such a nice development! The interface looks good. 

1) Can understand its based on Harbour, but how's the look & feel (the GUI) is like this (based on)? With HMG this interface can be made but yours is what? A proprietary or open source? 

2)Export/Import is not working?!

3)Report->Can be exported to Pdf/Word - but why you've not included MS-EXCEL? Normally dbfs are 1st exported to Excel and from excel it becomes easier for further manipulation/migration to other platforms.

4) Will this open a dbf in a multi-user environment without any risk? I didn't dared to test my live data from the server.

5) How to open a dbf with NTX indexes (single or multiple index files)?

Regards,

Swapan

India.

[Antonio Linares]

Swapan,

1. We use FiveWin (FWH) as the GUI library: www.fivetechsoft.com There
is a free demo version that you can download from there. It is
propietary software.

2. Yes, we have not completed yet that option. FiveDBU is a work in
progress, so all the feedback is really welcome :)

3. FWH provides that functionality but we have not included it in the
report preview and you are right, it should be there :)

4. FiveDBU is a work in progress so use it at your own risk. It should
not destroy any data, but better make a backup before just in case :)

5. We are going to review it.

Thanks for your kind words and feedback :-)


Antonio

[SD]

@Antonio Linares:

On Thursday, 9 May 2013 12:33:19 UTC+5:30, Antonio Linares wrote:

Swapan,

Thanks for your prompt reply and clarifying the things. 

 

4. FiveDBU is a work in progress so use it at your own risk. It should
not destroy any data, but better make a backup before just in case :)

I actually meant FiveDBU's ability to open the dbf in shared/exclusive mode. So even if any dbf is IN USE by any application over the network, the Sys Admin. can open it in shared mode for his/her work or case could be vice versa (sys admin can open a dbf in shared mode using FiveDBU, and any application using that dbf won't get stuck).

Regards,

Swapan

http://www.swapandas.com/

[Antonio Linares]

Swapan,

FiveDBU manages your data the same way your Harbour apps behave. If
you open a DBF in exclusive mode, then you are stopping others for
opening it in shared mode.

Antonio

2013/5/9 SD <swapan...@gmail.com>:

[Gmail]

Hello Antonio,

Nice utility but I would like to mention two details:

1- When you try to open a DBF (just clicking over it) and pointing FiveDBU
to open it then I get the attached error.
2- FiveDBU.ini should be created in the same folder as the fivedbu.exe. It
creates a copy of fivedbu.ini in any place I call the program (I have it's
folder in my path).

I hope it will serve to help you improve the program.
Thanks,

Qatan

[Antonio Linares]

Qatan,

Here you have a new FiveDBU build with those issues solved:

https://code.google.com/p/fivewin-contributions/downloads/detail?name=fivedbu_20130514.zip&can=2&q=

many thanks for your feedback :)

Antonio

2013/5/13 Gmail <wanst...@gmail.com>:

[JohanDees]

Haha, I got a working DBU now in linux in console mode, as I was searching for.

Found a clipper 5.3 version and with the example/dbu hints it worked!

Op dinsdag 14 mei 2013 09:52:11 UTC+2 schreef Antonio Linares het volgende:

[Gmail]

Hello Antonio,

Thanks for FiveDBU.
I tried to open a file that is not a DBF. It gave an error (attached).
I would like to know how do you generate the error log. Is it internal
FiveWin procedure or is the source code somewhere to the public?
I am interested because the error log is very good. In special the part of
"Variables in use"
Regards,

Qatan

[Antonio Linares]

Qatan,

It is generated by the FiveWin error system. It belongs to FiveWin,
but you can get it from the FWH demo from:
http://www.fivetechsoft.com/files/6.12/fwh.exe look for errsysw.prg in
source/function folder.

Glad to know that you enjoy it :-)

regards,

Antonio

2013/7/3 Gmail <wanst...@gmail.com>:

> --
> --
> You received this message because you are subscribed to the Google
> Groups "Harbour Users" group.
> Unsubscribe: harbour-user...@googlegroups.com
> Web: http://groups.google.com/group/harbour-users
>
> --- You received this message because you are subscribed to a topic in the
> Google Groups "Harbour Users" group.
> To unsubscribe from this topic, visit

> https://groups.google.com/d/topic/harbour-users/pTx5POBJ1hM/unsubscribe.

[Gmail]

Hello Antonio,

>It is generated by the FiveWin error system. It belongs to FiveWin,
>but you can get it from the FWH demo from:
>http://www.fivetechsoft.com/files/6.12/fwh.exe look for errsysw.prg in
>source/function folder.

Thanks for your help.

>Glad to know that you enjoy it :-)

Yes, I really liked it. I believe it will help to find the error in certain
circumstances.
Regards,

Qatan

[Gmail]

Hello Antonio,

>It is generated by the FiveWin error system. It belongs to FiveWin,
>but you can get it from the FWH demo from:
>http://www.fivetechsoft.com/files/6.12/fwh.exe look for errsysw.prg in
>source/function folder.

Thanks for your help.

>Glad to know that you enjoy it :-)

[SD]

Dear Antonio Linares:

PLEASE NOTE: If a dbf file, doesn't has an extension ".dbf", than FiveDBU is unable to open it, though its a valid dbf file. Actually there's no option as file options have "*.dbf". 

Moreover, if I try to open such a dbf  directly in this way:

fivedbu mydbf.set

It throws errors, and doesn't opens.

WHY SUCH A NEED:

Well, certain parameter files in dbf formats could be kept in this way so that normal users don't make changes to them, and are also can be identified as parameter files with a separate extension (*.set or anything else). And system access the data from these files without any special routine as they are normal dbfs only.

Thanks for understanding,

Regards,

Swapan

[Antonio Linares]

Swapan,

You can easily rename the file, or make a copy of it with another name

Anyhow, full source code is provided so you can easily modify it.

regards

Antonio

2013/7/9 SD <swapan...@gmail.com>:

[SD]

My post was intended for sort of "feature request", and not to be treated as "error reporting".

Swapan,
You can easily rename the file, or make a copy of it with another name

 

Yes, that can be done when one is in drastic need......

Moreover, I have multiple such files. So for me "foxplus" still comes as very handy tool.

 

Anyhow, full source code is provided so you can easily modify it. 

Not checked. And your executable is sufficient for me:)

Can't something be done in config. file? FiveDBU will pick the "additional" defined file specs from the config. file. So normal behaviour remains unchanged and also caters to "special" requests like this.

BTW, the old Clipper dbu still opens such dbf:

dbu mydbf.set

Regards,

Swapan

[Antonio Linares]

Swapan,

I do appreciate your feedback, thanks :-)

regards

Antonio

2013/7/9 SD <swapan...@gmail.com>:

[Otto Shimer]

I was playing with Clipper 501 and, this version of dbu compiled and linked 32bit. It is  Nantucket's 1990 version.