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