Ventajas de usar Array con TXBrowse

Ventajas de usar Array con TXBrowse

Postby Compuin » Mon Apr 05, 2021 11:01 pm

Hola,

Cuando utilizo mi conexion para abrir una tabla de Mysql, normalmente lleno el TXBrowse con un Array de los registros de la tabla (Una especie de Cursor).

Cual es la ventaja/desventaja de hacerlo asi en lugar de abrir la tabla y llenar directamente el TXBrowse con los registros de la misma?
FWH 20.12
Hbmk2 32/64 Bits (Build 19.29.30133)
Microsoft Visual C 32 Bits
MySql 8.0.24 32/64 Bits
VS Code
Compuin
 
Posts: 1213
Joined: Tue Dec 28, 2010 1:29 pm
Location: Quebec, Canada

Re: Ventajas de usar Array con TXBrowse

Postby nageswaragunupudi » Tue Apr 06, 2021 7:42 am

If you open the MySQL query with FWH built-in MySql/MariaLib or TDolphin or TMySql or ADO you better directly use the query with TXBrowse. This enables editing of the records also and saves the time to convert into an array.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10308
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Ventajas de usar Array con TXBrowse

Postby Compuin » Tue Apr 06, 2021 11:53 am

Thank you Mr. Rao

I understand it to save time, but my specific question is why many use fixes to fill the TXBrowse with data and manipulate it with options to enter / edit / delete instead of going directly to the table/database ... this is a good practice?
FWH 20.12
Hbmk2 32/64 Bits (Build 19.29.30133)
Microsoft Visual C 32 Bits
MySql 8.0.24 32/64 Bits
VS Code
Compuin
 
Posts: 1213
Joined: Tue Dec 28, 2010 1:29 pm
Location: Quebec, Canada

Re: Ventajas de usar Array con TXBrowse

Postby nageswaragunupudi » Tue Apr 06, 2021 1:17 pm

Compuin wrote:Thank you Mr. Rao

I understand it to save time, but my specific question is why many use fixes to fill the TXBrowse with data and manipulate it with options to enter / edit / delete instead of going directly to the table/database ... this is a good practice?


I do not clearly understand your question.
I shall be glad if you can explain more elaborately.
Thanks.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10308
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 44 guests