FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour New FWH 18.04
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
New FWH 18.04
Posted: Mon Jun 04, 2018 06:35 AM
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: New FWH 18.04
Posted: Thu Jun 07, 2018 06:03 PM

In another thread there is mention a new update to this release would be posted.

Can you please advise when the update is posted so we can download that one. Apparently it addresses issues with the DIALOG in xHarbour.

Thanks.

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
Posts: 811
Joined: Tue May 06, 2008 04:28 AM
Re: New FWH 18.04
Posted: Fri Jun 08, 2018 12:28 AM
TimStone wrote:In another thread there is mention a new update to this release would be posted.

Can you please advise when the update is posted so we can download that one. Apparently it addresses issues with the DIALOG in xHarbour.

Thanks.


Hi Mr. Tim,

The new release was already published. I already downloaded it.
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: New FWH 18.04
Posted: Fri Jun 08, 2018 03:45 AM
TimStone wrote:In another thread there is mention a new update to this release would be posted.

Can you please advise when the update is posted so we can download that one. Apparently it addresses issues with the DIALOG in xHarbour.

Thanks.

The issue pertains to MariaDB.
Not to dialogs as such.
Regards



G. N. Rao.

Hyderabad, India
Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: New FWH 18.04
Posted: Fri Jun 08, 2018 11:52 PM

Thank you.

I suppose it is time to start playing with SQL ...

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
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Re: New FWH 18.04
Posted: Sat Jun 09, 2018 03:21 PM
Tim

I use MS Access and ( free ) Sql Express Server 2017 .. the nice thing about this combination . is you can use the same code for both and just change the connection string and your code is ( virtually ) seamless.

The only quirk about MS Access is quering by datetime .. and you have to use hash tags to surround your query dates instead of single quotes ..:

Code (fw): Select all Collapse
     cSQL := "SELECT * from WORKORD"
     If xDatabase = "S"  // sql server
        cSQL += " where date_out >= '"+DTOC(LDATE)+"' and date_out <= '"+DTOC(HDATE)+"'"
     Else                       // ms access
        cSql += " WHERE [Date_Out] >= #"+dtoc(lDate)+"# And [Date_Out] <= #"+dtoc(hDate)+"#"
     ENdif
     cSQL += " and wotype = '2' and ageneid = '"+xAGENEID+"' order by DATE_out"


This allows you to use MS Access as a portable database for those customers that can not afford MS Sql Server, however, you can also deploy Sql Express to your customer, but is more difficult for a small Customer to manage.... and you can forget about ANY optlock headaches and cranky dbf access on network shares.

Rao has created a whole set of ado wrappers to simplify the connections, recordsets, etc .. see \source\function\adofuncs.prg for the syntax .. or you can do it the ole fashioned ansi sql way .. \samples\AdoRick.prg ( ms access )

I only use DBfCdx for creating temporary tables for reports.

Rick Lipkin
Posts: 1048
Joined: Mon Oct 24, 2005 09:54 AM
Re: New FWH 18.04
Posted: Fri Jun 15, 2018 10:29 AM

New SPINNER BUTTONS <cbmp1>,<cbmp2> and RIHGTTOLEFT for TGet seems not functioning! Headers (.CH) wrong?

Regards,
Günther
---------------------------------
office@byte-one.com
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
Re: New FWH 18.04
Posted: Fri Jun 15, 2018 10:38 AM

Günther,

Could you provide an example to test that was working fine and it is not working now ? thanks

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1048
Joined: Mon Oct 24, 2005 09:54 AM
Re: New FWH 18.04
Posted: Fri Jun 15, 2018 11:47 AM

Antonio, the source of TGet-class is ok, but in fivewin.ch the new clausulas are not present!

Regards,
Günther
---------------------------------
office@byte-one.com
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: New FWH 18.04
Posted: Fri Jun 15, 2018 01:55 PM
The new clauses are present only in @ row,col GET command but not in REDEFINE command. In fact, we did not test this feature with resources.

However, can you test with resources and offer your feedback?
In the REDEFINE GET command, can you please replace the line
Code (fw): Select all Collapse
             [ <spin: SPINNER> [ON UP <SpnUp>] [ON DOWN <SpnDn>] [MIN <Min>] [MAX <Max>] ] ;


with
Code (fw): Select all Collapse
            [ <spin: SPINNER> [BUTTONS <bmp1>,<bmp2> ] [ON UP <SpnUp>] [ON DOWN <SpnDn>] [MIN <Min>] [MAX <Max>] ] ;


Please ensure that you do not include VSCROLBAR in the style while defining the resource in the rc file.
Regards



G. N. Rao.

Hyderabad, India
Posts: 1048
Joined: Mon Oct 24, 2005 09:54 AM
Re: New FWH 18.04
Posted: Mon Jun 25, 2018 12:34 PM

Mr. Rao,
I have tested for now oGet:lRightToLeft := .T. on get from resources.
Is functioning but the foreground-color is not respecting COLOR-Clause (always black).

Regards,
Günther
---------------------------------
office@byte-one.com
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: New FWH 18.04
Posted: Mon Jun 25, 2018 03:49 PM

Painting is done with ::nClrText.
May I know how did you set the color?

Regards



G. N. Rao.

Hyderabad, India
Posts: 1048
Joined: Mon Oct 24, 2005 09:54 AM
Re: New FWH 18.04
Posted: Tue Jun 26, 2018 08:06 PM
Code (fw): Select all Collapse
REDEFINE GET obetrag VAR finanz->betrag ID 107 OF oDialog PICTURE PIC_BETRAG MESSAGE "Betrag" UPDATE COLOR NSAYFARBE_ALL_INVERS,NSAYFARBE_ALL FONT oFont_konto WHEN larbeit .and. !finanz->check1
Regards,
Günther
---------------------------------
office@byte-one.com

Continue the discussion