FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posts: 79
Joined: Wed Mar 06, 2019 08:28 PM
¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posted: Fri Jun 21, 2019 09:19 AM

Estimados compañeros

Estoy ocupando BROWSER para mostrar una tabla:

use final
XBROWSER (cTitulo) COLUMNS aCols FASEDIT

aCols me imagino que son las cabeceras, pero se multiplican en toda la columna (osea en los registros que son numéricos los cambian a caracteres y los llenan con el nombre de la cabecera).¿ Porqué se produce ese error, alguien sabe?

Por su ayuda desde ya muchas gracias.

Waldemar

"Porque Jehová da la sabiduría , Y de su boca viene el conocimiento y la inteligencia Proverbios 2:6"

FWH 1903 + Bcc7 + PellesC + XEdit easycomp613@gmail.com

Waldemar
Colbún Chile
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posted: Fri Jun 21, 2019 09:56 AM
COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.

Example:
Code (fw): Select all Collapse
USE CUSTOMER NEW
XBROWSER "CUSTOMER" TITLE "Customers" COLUMNS "FIRST", "CITY", "SALARY"


COLUMNS clause is optional.

Most of the times,
XBROWSER cAlias
is enough
Regards



G. N. Rao.

Hyderabad, India
Posts: 79
Joined: Wed Mar 06, 2019 08:28 PM
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posted: Fri Jun 21, 2019 02:41 PM
nageswaragunupudi wrote:COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.

Example:
Code (fw): Select all Collapse
USE CUSTOMER NEW
XBROWSER "CUSTOMER" TITLE "Customers" COLUMNS "FIRST", "CITY", "SALARY"


COLUMNS clause is optional.

Most of the times,
XBROWSER cAlias
is enough


Mr. Rao

There is form to shown headers?


Waldemar
"Porque Jehová da la sabiduría , Y de su boca viene el conocimiento y la inteligencia Proverbios 2:6"

FWH 1903 + Bcc7 + PellesC + XEdit easycomp613@gmail.com

Waldemar
Colbún Chile
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posted: Fri Jun 21, 2019 03:03 PM
Code (fw): Select all Collapse
USE CUSTOMER
XBROWSER "CUSTOMER" COLUMNS "FIRST","LAST" SETUP oBrw:cHeaders := { "FirstName", "LastName" }
Regards



G. N. Rao.

Hyderabad, India
Posts: 79
Joined: Wed Mar 06, 2019 08:28 PM
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posted: Fri Jun 21, 2019 03:32 PM
nageswaragunupudi wrote:
Code (fw): Select all Collapse
USE CUSTOMER
XBROWSER "CUSTOMER" COLUMNS "FIRST","LAST" SETUP oBrw:cHeaders := { "FirstName", "LastName" }


Mr. Rao

Excellent

Thank you very much, i`ll work on it.

Waldemar
"Porque Jehová da la sabiduría , Y de su boca viene el conocimiento y la inteligencia Proverbios 2:6"

FWH 1903 + Bcc7 + PellesC + XEdit easycomp613@gmail.com

Waldemar
Colbún Chile
Posts: 79
Joined: Wed Mar 06, 2019 08:28 PM
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Posted: Fri Jun 21, 2019 04:44 PM

Mr. Rao

I wrote this:

XBROWSER TITLE "Archivo Final para Recursos Humanos";
SETUP oBrw:cHeaders := aTem//;

When push the button for excel, i get this error:

Application

Path and name: D:\JOB\Sindicato\sindicato.exe (32 bits)
Size: 7,479,808 bytes
Compiler version: Harbour 3.2.0dev (r1801051438)
FiveWin version: FWH 19.03
C compiler version: Borland/Embarcadero C++ 7.0 (32-bit)
Windows version: 6.2, Build 9200

Time from start: 0 hours 0 mins 14 secs
Error occurred at: 21/06/2019, 12:34:27
Error description: (DOS Error -2147352567) WINOLE/1007 No se puede obtener la propiedad Paste de la clase Worksheet. (0x800A03EC): Microsoft Excel

Stack Calls

Called from: => TOLEAUTO:PASTE( 0 )
Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:TOEXCEL( 9801 )
Called from: xbrowser.prg => (b)XBROWSE( 193 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 697 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 983 )
Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1791 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 2006 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3546 )
Called from: => DIALOGBOXINDIRECTW( 0 )
Called from: .\source\classes\DIALOG.PRG => TDIALOG:ACTIVATE( 304 )
Called from: xbrowser.prg => XBROWSE( 304 )
Called from: Funciones.prg => GENXLSFINAL( 1078 )
Called from: Funciones.prg => (b)PROGRESO( 1851 )
Called from: .\source\classes\BUTTON.PRG => TBUTTON:CLICK( 179 )
Called from: .\source\classes\CONTROL.PRG => TBUTTON:HANDLEEVENT( 1755 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3546 )
Called from: => SENDMESSAGE( 0 )
Called from: .\source\classes\DIALOG.PRG => TDIALOG:COMMAND( 433 )
Called from: => TWINDOW:HANDLEEVENT( 0 )
Called from: .\source\classes\DIALOG.PRG => TDIALOG:HANDLEEVENT( 1136 )
Called from: => DIALOGBOXW( 0 )
Called from: .\source\classes\DIALOG.PRG => TDIALOG:ACTIVATE( 304 )
Called from: Funciones.prg => PROGRESO( 1871 )
Called from: Principal.prg => (b)MAIN( 169 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 697 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 983 )
Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1791 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 2006 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3546 )
Called from: => WINRUN( 0 )
Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:ACTIVATE( 1078 )
Called from: Principal.prg => MAIN( 193 )

Regards

Waldemar

"Porque Jehová da la sabiduría , Y de su boca viene el conocimiento y la inteligencia Proverbios 2:6"

FWH 1903 + Bcc7 + PellesC + XEdit easycomp613@gmail.com

Waldemar
Colbún Chile

Continue the discussion