FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour DOS accounting system to TWeb
Posts: 512
Joined: Mon Oct 17, 2005 10:38 AM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:00 AM

Hello Otto.
Very nice, and powerful. I'll give it a look.
Thanks a lot
Massimo

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:08 AM

Hello Massimo,
where in Italy are you from.
It seems to me that we live not far away from each other.
Best regards
Otto

Posts: 512
Joined: Mon Oct 17, 2005 10:38 AM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:17 AM

I'm at 50 km from the Austrian border (Udine)

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:29 AM

Hello Massimo,
yes, then we really do not live far from each other.
I am at home 4 km from the border with South Tyrol.
We should meet once.
Are you directly in Udine?
LG
Otto

Posts: 512
Joined: Mon Oct 17, 2005 10:38 AM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:41 AM

Hi Otto.
Give me your email so we can speak better without filling the post with personal stuff.

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:45 AM

Dear Otto,

When is the next Harbour users meeting at Sillian ? ;-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:53 AM

Hi Otto,

I have take look at you main menu and I was wondering if it was possible to go to a menuitem by pressing ENTER en a singleclick?
I noticed that it's working by doubleclick.
I just thinking about the customers, since they are used to the DOS-version, and then the navigation is via the arrows and pressing ENTER.
I still remember when my customers changed from de DOS-clipper version to the FW-version. They where not used to use to the mouse. :D It was faster navigating via the arrow and ENTER.
In my window version, they can still use the functionkeys :D

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 08:32 AM
Hello Mark,
exactly the same I tried to find out yesterday.

I think it is possible. There is a method $o->SetKey( VK_myKey, 'TGrid_myfunctzion()' ); .
I am just starting with TWeb. I think we have to look into TControl and TGred classes.


ImportFromDBF( cDbf, cTable, cColPrefix, nMultiRowSize, aFields, cAutoIncFld, cCharSet, lAddTS, bProgress )
This function works perfectly. Thank you for showing me this function.

It is important that you set nMultiRowSize.
nMultiRowSize defaults to 20 records per batch.
If the data contains binary data (BLOB) it defaults to 1.
This method reads and inserts data in batches.
Each batch containing 20 records. This is slower than inserting all records in one batch.
If we increase nMultiRowSize, the speed will increase.


With nMultiRowSize := Lastrec() it is 5 times faster than my function.
Thank you and best regards
Otto





Best regards
Otto
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 08:36 AM
Hello Mark,
exactly the same I tried to find out yesterday.

I think it is possible. There is a method $o->SetKey( VK_myKey, 'TGrid_myfunctzion()' ); .
I am just starting with TWeb. I think we have to look into TControl and TGrid classes.


ImportFromDBF( cDbf, cTable, cColPrefix, nMultiRowSize, aFields, cAutoIncFld, cCharSet, lAddTS, bProgress )
This function works perfectly. Thank you for showing me this function.

It is important that you set nMultiRowSize.
nMultiRowSize defaults to 20 records per batch.
If the data contains binary data (BLOB) it defaults to 1.
This method reads and inserts data in batches.
Each batch containing 20 records. This is slower than inserting all records in one batch.
If we increase nMultiRowSize, the speed will increase.


With nMultiRowSize := Lastrec() it is 5 times faster than my function.
Thank you and best regards
Otto





Best regards
Otto
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 05:14 PM
Hello Mark,


I have take look at you main menu and I was wondering if it was possible to go to a menuitem by pressing ENTER en a singleclick?
I noticed that it's working by doubleclick.
I just thinking about the customers, since they are used to the DOS-version, and then the navigation is via the arrows and pressing ENTER.
I still remember when my customers changed from de DOS-clipper version to the FW-version. They where not used to use to the mouse. :-) It was faster navigating via the arrow and ENTER.
In my window version, they can still use the functionkeys :-)



If you has defined property bSelect (without parentheses ) automatically invoke return key
Código: [Select all] [Expandir/Colapsar]

$o = new TGrid( $oWnd, 'mygrid', 60, 10, 350, 500 );
$o->cTitle = 'Test key [Ins] & [Del]';
$o->SetRight( 10 );
$o->SetBottom( 10 );
$o->SetKey( VK_INSERT, 'TGrid_Insert()' );
$o->SetKey( VK_DELETE, 'TGrid_Delete()' );
$o->bSelect = 'TGrid_Select' ;
Best regards
Otto
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 06:33 PM
Otto,

I see when pressing ENTER in the Tgrid, the field can directly me modified, but is it possible to change the page
https://winhotel.space/tweb.examples/fibu1
so if the customer press ENTER, the dialog 'Value - test' ,like in your example is displayed?

I will also install the tweb on my server, so I can also play with it :-)
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 07:04 PM

Hello Mark,
I think it is possible.
We should also post our questions on TWeb forum. Carles is there an helps.
Yes this is the next step if we want to use Grid as a menu.
Please post if you have a solution.
Do you have a inhouse server?
Best regards
Otto

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 08:08 PM

Otto,

I will let you know if I find a solution.
I have a inhouse server for testing, but I also have a resellerhosting on a external site, that host my website, and the sites of my clients.

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 6755
Joined: Wed Feb 15, 2012 08:25 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 09:58 PM
Silvio.Falconi wrote:do you're using DBF ?


Is it possible to use DBF files in PHP? ( please read )
https://www.php.net/manual/es/intro.dbase.php
https://www.php.net/manual/es/book.dbase.php

You have to add an extension
https://pecl.php.net/package/dbase

Is it advisable to use DBF as databases?
NO, NO, NO
Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Posts: 1789
Joined: Tue Oct 11, 2005 05:01 PM
Re: DOS accounting system to TWeb
Posted: Mon Apr 08, 2019 10:05 PM
Hi I Work with fweb and have Many App, i think that the grid control is not the most adecuate to make a main menú.
Is more suitable a grupos of buttons
Salu2

Carlos Vargas

Desde Managua, Nicaragua (CA)