Page 1 of 1

¿ Porqué se distorsiona XBROWSER con COLUMNS ?

Posted: Fri Jun 21, 2019 9:19 am
by 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 _ 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

Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?

Posted: Fri Jun 21, 2019 9:56 am
by 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

USE CUSTOMER NEW
XBROWSER "CUSTOMER" TITLE "Customers" COLUMNS "FIRST", "CITY", "SALARY"
 
COLUMNS clause is optional.

Most of the times,
XBROWSER cAlias
is enough

Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?

Posted: Fri Jun 21, 2019 2:41 pm
by wyerco613
nageswaragunupudi wrote:COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.

Example:

Code: Select all

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

Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?

Posted: Fri Jun 21, 2019 3:03 pm
by nageswaragunupudi

Code: Select all

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

Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?

Posted: Fri Jun 21, 2019 3:32 pm
by wyerco613
nageswaragunupudi wrote:

Code: Select all

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

Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?

Posted: Fri Jun 21, 2019 4:44 pm
by 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