FiveWeb (FiveWin days are numbered)

Marcelo Via Giglio
Posts: 1033
Joined: Fri Oct 07, 2005 3:33 pm
Location: Cochabamba - Bolivia

Re: FiveWeb (FiveWin days are numbered)

Post by Marcelo Via Giglio »

Tim,

if you make a database backup with dump or other similar technique, you can recreate a table, because you can save the tables´s data in plain text. If there are many companies or users using DBMS is because it are working good. Try to work with SQL and can never leave it

Is important to keep open mind, because the problems define the technique and the tools. Try to put dbfs for a financial system, for an stand alone user is ok or for little systems, I know the dbfs are fast and easy, but own problems is we want not to change or we have fear of change, the same happening with the WEB systems, this works very good, there are many samples, now I am using a web system to write this.

Not because we want not to see the things they don´t exist, the time go fast and there many things waiting for us, I like and love very much FiveWin, but we can use it with different approach.

I don´t want to trouble anyone with this, just I wanted to give my point of view, and sorry for my bad English

saludos

Marcelo
George
Posts: 710
Joined: Tue Oct 18, 2005 6:49 pm

Re: FiveWeb (FiveWin days are numbered)

Post by George »

Could be ADS from Sybase:
http://www.sybase.com/products/database ... baseserver
an alternative to SQL to be used with Harbour + FW?

Regards,

George
Marcelo Via Giglio
Posts: 1033
Joined: Fri Oct 07, 2005 3:33 pm
Location: Cochabamba - Bolivia

Re: FiveWeb (FiveWin days are numbered)

Post by Marcelo Via Giglio »

George,

yes ADS is a good alternative, and I can say it is unique because you can access the data in the classic way table navigation ISAM and SQL. The SQL results can manipulate like a dbf tables.

Migrate from classic DBF/CDX/NTX is really easy

ADS has many of features of DBMS, triggers, procedures, referential integrity and more, you can use it in stand alone (no server) way or in Client/Sever architecture, all with the same source code.

And yes, we need to pay for a server

regards

Marcelo
George
Posts: 710
Joined: Tue Oct 18, 2005 6:49 pm

Re: FiveWeb (FiveWin days are numbered)

Post by George »

Thanks Marcelo for your answer.
I am ADS user, since many years ago, but using only ADS as substitute for DBF.
My question is because I am thinking to migrate to SQL and I would like to know if ADS could be also a good substitute for standard SQL like MS-SQL and MySQL.

I would appreciate any input regarding this matter.

Regards,

George
Marcelo Via Giglio
Posts: 1033
Joined: Fri Oct 07, 2005 3:33 pm
Location: Cochabamba - Bolivia

Re: FiveWeb (FiveWin days are numbered)

Post by Marcelo Via Giglio »

George,

of course, you can use ADS like other DBMS like MS SQL or MySQL. You can use SQL with your DBF now without change your code, you don´t need a ADS remote server, SQL work with local server too, the difference with remote server is the transactions, with local server don´t work the transactions.

But the problem is the cost, you can use MSSQL express or MadiaDB (MySql has some licence restrictions for commercial use) for free ADS Server is not free

This sample is from 2006

Code: Select all

#include "ads.ch"
#include "fivewin.ch"    

#command SET FILETYPE TO <x:NTX,CDX,ADT>                              ;
      => AdsSetFileType( if( upper( <(x)> ) == "NTX", 1,              ;
                         if( upper( <(x)> ) == "CDX", 2, 3 ) ) )


REQUEST ADS
REQUEST DBFFPT

function main()
LOCAL oDlg, consulta := SPACE(400), oLbx, path := "                            ",;
      connect, tipo := "ADT"

   RddRegister("ads",1)
   RddSetDefault("Ads")
   AdsSetServerType ( 1 ) // local
   AdsSetFileType(3)

   SET DELETED ON
   adsRightsCheck( .F. )

   DEFINE DIALOG oDlg RESOURCE "consulta" 

      REDEFINE COMBOBOX tipo ID 108 ITEMS {"NTX","CDX","ADT"} OF oDlg ;
                        ON CHANGE AdsSetFileType( IF( tipo == "NTX", 1,              ;
                                                      IF( tipo == "CDX", 2, 3 ) ) )
          REDEFINE GET path ID 102 OF oDlg

      REDEFINE BUTTON ID 103 OF oDlg  ACTION ( AdsDisconnect(AdsConnection()),;
                                               IF ( AdsConnect60( path , 7,"ADSSYS"), ;
                                connect:setcolor(CLR_GREEN, CLR_GREEN),;
                                                    connect:setcolor(CLR_HRED, CLR_HRED ) ;
                              ),; 
                                               connect:refresh() ;
                          )
      REDEFINE SAY connect PROMPT "  " ID 110 OF oDlg COLOR CLR_HRED, CLR_HRED
          REDEFINE GET consulta ID 104 OF oDlg
      REDEFINE BUTTON ID 106 OF oDlg ACTION  resultado( consulta )
                                
      REDEFINE BUTTON ID 107 OF oDlg ACTION oDlg:end()

   ACTIVATE DIALOG oDlg

   //AdsDisconnect(AdsGetConnectionHandle())

   AdsDisconnect(AdsConnection())

return  nil

FUNCTION resultado( consulta )
    LOCAL oDlg, oLbx,e

    
    ADSCreateSQLStatement("SQLarea",2)
   
    IF ADSExecuteSQLDirect( consulta ) 
       TRY
         
         DEFINE DIALOG oDlg RESOURCE "resultado"

      REDEFINE LISTBOX oLbx FIELDS ALIAS "SQLarea" ID 101 OF oDlg
          REDEFINE SAY PROMPT "RESULTADO : " + ALLTRIM( STR ( SQLarea -> ( LASTREC() ) ) )  ID 200 OF oDlg COLOR CLR_BLUE
      REDEFINE BUTTON ID 102 OF oDlg ACTION oDlg:end()
      REDEFINE BUTTON ID 103 OF oDlg ACTION oLbx:report()

         ACTIVATE DIALOG oDlg
     sqlarea -> ( DBCLOSEAREA() )

       CATCH e
         ? "COMANDO EJECUTADO"
       END
    ELSE
        MSGINFO("Error en la ejecución de la consulta")
    sqlarea -> ( DBCLOSEAREA() )
    ENDIF
        
RETURN NIL
 
To test put the path where are yours DBFs and connect, then put a SQL sentence and execute

and the exe you can download from:

https://app.box.com/s/81r7qo8a996h4lvs2nh6

regards

Marcelo
User avatar
codemaker
Posts: 208
Joined: Wed Dec 03, 2008 4:48 pm
Location: Belgrade, Serbia

Re: FiveWeb (FiveWin days are numbered)

Post by codemaker »

I am in finishing process of some application converted for WEB
It shows the same on any browser (no positioning issues)
Uses DBF on the server
Uses RC files to create dialogs (Peles C is the tool I use for RC files)
The speed is excellent (from 10,000 records SCOPE delivers 600 records in 3-4 seconds) after then it is just a mater of browsing and showing the results in GET or other controls

I think this will be the way to go generally.
Library alow MySql connection and manipulation
Does not need IIS to be installed, Apache can do ok or Vertrigo (which I am using for testing
I am already preparing another app to be converted and also the old web app will use this LIB in a near future
If the app is combined with FastReport - ir produces great reports (I am still learning all FR features but it will be done)

It simulates Fivewin style/logic of controls management, combined with web logic of accessing data and controls



Login Screen
Image

Part of menu
Image

Company data
Image

Deductions defined
Image

Company Pay policies
Image

Holiday packages defined
Image

Employees browse (with report button)
Image

One selected employee data
Image

Employee's deduction defined
Image

Tax statuses
Image

Report for employees - MAsted list. Can export data to many formats. This is PDF - no additional DLL or LIB needed
Image

Hours Worked browsing
Image

Users of the system, this can be done only by SUPERVISOR. Also defines (checkboxes) what each uses can acces in program (right side)
Image

Report - Hours working
Image

In a few days I will prepare a demo data and will post here the link so you can see it in live. Right now I have only "real" data and cannot expose anywhere.
elvira
Posts: 462
Joined: Fri Jun 29, 2012 12:49 pm

Re: FiveWeb (FiveWin days are numbered)

Post by elvira »

Woow !!!. What tool aré you using ?
User avatar
Massimo Linossi
Posts: 474
Joined: Mon Oct 17, 2005 10:38 am
Location: Italy

Re: FiveWeb (FiveWin days are numbered)

Post by Massimo Linossi »

It's a fantastic job, many compliments. I'm interested too to know how you made it.
User avatar
Adolfo
Posts: 815
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile
Contact:

Re: FiveWeb (FiveWin days are numbered)

Post by Adolfo »

Codemaker

Excelent, but I have a question, Does it work only in Win Servers, can I use a Linux one ?
;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Lenovo Legion Y520, 16GB Ram, 1 TB NVME M.2, 1 TB SSD, GTX 1050
User avatar
Enrico Maria Giordano
Posts: 7355
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Contact:

Re: FiveWeb (FiveWin days are numbered)

Post by Enrico Maria Giordano »

Boris,

unfortunately, there are serious problems with CGI EXE web applications: they won't run using default web server setting. So you probably can't run them in the customers web server. Another problem is that they require Windows, unless you compile your CGI EXE for other systems, can you?

EMG
User avatar
Lailton
Posts: 99
Joined: Fri Jul 20, 2012 1:49 am
Location: Brazil
Contact:

Re: FiveWeb (FiveWin days are numbered)

Post by Lailton »

Congratulations Boris,

Take this opportunity to leave my sincere apology for the delay in meeting their requests.

Great job :o
Regards,
Lailton Fernando Mariano
https://www.harbour.ninja
Jack
Posts: 249
Joined: Wed Jul 11, 2007 11:06 am

Re: FiveWeb (FiveWin days are numbered)

Post by Jack »

Great !!

What is the name of this product ?

Thanks
User avatar
codemaker
Posts: 208
Joined: Wed Dec 03, 2008 4:48 pm
Location: Belgrade, Serbia

Re: FiveWeb (FiveWin days are numbered)

Post by codemaker »

Enrico Maria Giordano wrote:Boris,

unfortunately, there are serious problems with CGI EXE web applications: they won't run using default web server setting. So you probably can't run them in the customers web server. Another problem is that they require Windows, unless you compile your CGI EXE for other systems, can you?

EMG
Enrico, I don't have any problem running this application on
XP IIS IIS5
Windows 7 IIS IIS6
Windows 8 IIS
Windows Server 2003 IIS
Windows Server 2008 IIS
Windows Server 2012 IIS

Also any browser shows the same result - IE, FF, Safari, Chrome
Also I can access the app from Android based Samsung tablet/phone (the dimensions are not ok phone is small) and IOS Apple tablet
Also from any Makitosh computers

The web app can be compiled with a minor changes (path pointing) for Linux and can run SQL using Dolphin. THis way the app can run on Linux machines too.
In case of using SQL, some data maintanence will be changed of course - There is no databased apps which can be run on both systems without changes and adjustments as you know.

This web app can also run on Apache so we don't need IIS at all
I am testing the app also on Vertrigo server, works perfect

I am testing the app right now on all Windows servers named above. No single problem detected.
In the company I am working with we have all these type of servers and we tested the app on all of them.

CGI/EXE can run without problem. One of the older app, runs by accessing the XXX.DLL which in turn calls XXX.EXE and all this works perfect on any customer server (we have a hundreds of installations on their servers which are then accessed by many of their clients - so thousands of users are accessing that app without problem for more than 10 years by now) With this library I call EXE files directly (or .WEB files in case of Linux version)

As I see it now, this new app library is much better and is also more reliable and easier to maintain and work with it from the users side, because it follows the Windows logic of data entering and use.

The only problem is there is no comprehensive help file or any useful documentation. I was digging in the dark, but without the help of author I wouldn't be able to finish.
Now I have enough knowledge and hope will have time to write a good help file. This is why I cannot say more about the LIB itself, it is useless without documentation for other people. Except author and me.

With this previews I wanted to show what in my opinion is one of the tools we should consider while moving to web. As far as the (X)Harbour/SQL users are in question.
User avatar
codemaker
Posts: 208
Joined: Wed Dec 03, 2008 4:48 pm
Location: Belgrade, Serbia

Re: FiveWeb (FiveWin days are numbered)

Post by codemaker »

Adolfo wrote:Codemaker

Excelent, but I have a question, Does it work only in Win Servers, can I use a Linux one ?
Absolutelly, you can use Linux also and SQL, with Dolphin
elvira
Posts: 462
Joined: Fri Jun 29, 2012 12:49 pm

Re: FiveWeb (FiveWin days are numbered)

Post by elvira »

Boris,

I guess You are using Fiveweb from Laiton??
Post Reply