¿ Porqué se distorsiona XBROWSER con COLUMNS ?

[wyerco613]

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

[nageswaragunupudi]

COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.

Example:

Code: Select all  Expand view

USE CUSTOMER NEW
XBROWSER "CUSTOMER" TITLE "Customers" COLUMNS "FIRST", "CITY", "SALARY"
 

COLUMNS clause is optional.

Most of the times,
XBROWSER cAlias
is enough

[wyerco613]

COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.

Example:

Code: Select all  Expand view

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

[nageswaragunupudi]

Code: Select all  Expand view

USE CUSTOMER
XBROWSER "CUSTOMER" COLUMNS "FIRST","LAST" SETUP oBrw:cHeaders := { "FirstName", "LastName" }
 

[wyerco613]

Code: Select all  Expand view

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

[wyerco613]

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