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
¿ Porqué se distorsiona XBROWSER con COLUMNS ?
¿ Porqué se distorsiona XBROWSER con COLUMNS ?
"Porque Jehová da la sabiduría , Y de su boca viene el conocimiento y la inteligencia Proverbios 2:6"
FWH 1903 + Bcc7 + PellesC + XEdit
Waldemar
Colbún Chile
FWH 1903 + Bcc7 + PellesC + XEdit
Waldemar
Colbún Chile
- nageswaragunupudi
- Posts: 8017
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Contact:
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.
Example:
COLUMNS clause is optional.
Most of the times,
XBROWSER cAlias
is enough
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"
Most of the times,
XBROWSER cAlias
is enough
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Mr. Raonageswaragunupudi wrote:COLUMNS are not headers.
They are the expressions of field names to be shown. By default, all fields are shown.
Example:COLUMNS clause is optional.Code: Select all
USE CUSTOMER NEW XBROWSER "CUSTOMER" TITLE "Customers" COLUMNS "FIRST", "CITY", "SALARY"
Most of the times,
XBROWSER cAlias
is enough
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
Waldemar
Colbún Chile
FWH 1903 + Bcc7 + PellesC + XEdit
Waldemar
Colbún Chile
- nageswaragunupudi
- Posts: 8017
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Contact:
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Code: Select all
USE CUSTOMER
XBROWSER "CUSTOMER" COLUMNS "FIRST","LAST" SETUP oBrw:cHeaders := { "FirstName", "LastName" }
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
Mr. Raonageswaragunupudi wrote:Code: Select all
USE CUSTOMER XBROWSER "CUSTOMER" COLUMNS "FIRST","LAST" SETUP oBrw:cHeaders := { "FirstName", "LastName" }
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
Waldemar
Colbún Chile
FWH 1903 + Bcc7 + PellesC + XEdit
Waldemar
Colbún Chile
Re: ¿ Porqué se distorsiona XBROWSER con COLUMNS ?
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
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
Waldemar
Colbún Chile
FWH 1903 + Bcc7 + PellesC + XEdit
Waldemar
Colbún Chile