FiveWeb (FiveWin days are numbered)

[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]

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]

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]

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]

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

[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


Part of menu


Company data


Deductions defined


Company Pay policies


Holiday packages defined


Employees browse (with report button)


One selected employee data


Employee's deduction defined


Tax statuses


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


Hours Worked browsing


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


Report - Hours working


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]

Woow !!!. What tool aré you using ?

[Massimo Linossi]

It's a fantastic job, many compliments. I'm interested too to know how you made it.

[Adolfo]

Codemaker

Excelent, but I have a question, Does it work only in Win Servers, can I use a Linux one ?

[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

[Lailton]

Congratulations Boris,

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

Great job

[Jack]

Great !!

What is the name of this product ?

Thanks

[codemaker]

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.

[codemaker]

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]

Boris,

I guess You are using Fiveweb from Laiton??