Search found 32 matches: col1

Return to advanced search

Copy ARRAY filtered by column

Dear friends,

What is the most effective way to copy certain columns from an ARRAY to a new ARRAY:
eg ARRAY {"col1", "col2", "col3", "col4", "col5"}

new ARRAY {"col1", "col3", "col5"}

Best regards,
Otto
by Otto
Tue Nov 15, 2022 8:05 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Copy ARRAY filtered by column
Replies: 2
Views: 203

Re: Editing individual lines

... "FiveWin.ch" #include "XBrowse.ch" function Main() local oDlg, oFld, oBrw1, oBrw2 local aDat1, aDat2 aDat1:={{"Row1-Col1","Row1-Col2","Row1-Col3"},; {"Row2-Col1","Row2-Col2","Row2-Col3"},; {"Row3-Col1","Row3-Col2","Row3-Col3"},; ...
by MGA
Wed Mar 17, 2021 11:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Editing individual lines
Replies: 2
Views: 480

Re: Question to XBROWSE

I have solved for me!

But as suggestion for XBROWSE:
A function similar to "SKIP FOR bFor WHEN bWhen" espacially for rows with one or more editable cells.
z.B. "SKIP FOR empty(Col1)"
by byte-one
Tue Mar 03, 2020 12:14 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question to XBROWSE
Replies: 3
Views: 656

Excel SaveAs not working

... 1):Value := CHR(39) + 'Report Date = ' + DTOC( DATE() ) + ' @ ' + LEFT( TIME(), 5 ) nRow++ nRow++ // Header... oAs:Cells (nRow, 1):Value := 'data col1.' oAs:Cells(nRow, 1 ):Select() nRow++ lFirst := .F. ENDIF // Write to XLS oAs:Cells (nRow, 1):Value := CHR(39) + ALLTRIM( ctnrreq->reqno ) + ...
by cdmmaui
Thu Jul 05, 2018 6:56 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Excel SaveAs not working
Replies: 2
Views: 908

New FTDN February/Febrero 2018 (FWH 18.02)

... RowSet object now correctly recognizes initial sort order when sort clause includes aliased fields also. Example: When sql is "select fld1 as col1,fld2 as col2 from table t order by col2", initial order is recognized correctly as col2. When sql is "select fld1 as col2,fld2 as cole ...
by Antonio Linares
Fri Mar 09, 2018 12:01 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN February/Febrero 2018 (FWH 18.02)
Replies: 0
Views: 1337

Re: Import and Export to Excel

... can erase (hide) colums in Xbrowse, and then call the export in order to have a selected exell file. But is it also possible to have oBrw:ToExcel(col1,col3,col6,col9) or a array of selected cols ?
by Marc Venken
Wed Jun 14, 2017 2:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Import and Export to Excel
Replies: 32
Views: 18174

Re: 15.10 Browse problem

... about these columns. Recommended sytanx is : @ r.c (or) REDEFINE XBROWSE ...... DATASOURCE <Alias/oDbf/oRs/oQry/Array> ; COLUMNS "col1", "col2", ...... In this case, XBrowse examines the field properties of the columns and decides the optimal behavior required, like ...
by nageswaragunupudi
Thu Dec 31, 2015 3:57 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: 15.10 Browse problem
Replies: 27
Views: 8393

Re: TDolphin - from where I can download ?

... regards ! With oQry:SetWhere( <newWhereCond> ), you can reset the filter dynamically and view the re-filtered rows. oQry:SetOrder( "<col1>,<col2>" ) works For xbrowse you can let the user sort the browse order on any column without writing any special code. Just add ...
by Rimantas
Wed Mar 06, 2013 12:47 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDolphin - from where I can download ?
Replies: 18
Views: 4606

Re: TDolphin - from where I can download ?

... regards ! With oQry:SetWhere( <newWhereCond> ), you can reset the filter dynamically and view the re-filtered rows. oQry:SetOrder( "<col1>,<col2>" ) works For xbrowse you can let the user sort the browse order on any column without writing any special code. Just add ...
by nageswaragunupudi
Wed Mar 06, 2013 12:05 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDolphin - from where I can download ?
Replies: 18
Views: 4606

Pantalla ampliada

... siguiente: Cuando muestro un tcbrowse en pantalla leo de un fichero de configuración el tamaño de cada una de las columnas que lo componen. p.e.. col1=10, col2=100, col3=200. Al finalizar el browse grabo en ese fichero de configuracion el tamaño que tienen al final, por lo que si se cambio el ...
by miarcod
Sun Jul 01, 2012 10:26 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Pantalla ampliada
Replies: 1
Views: 580

pantalla ampliada

... siguiente: Cuando muestro un tcbrowse en pantalla leo de un fichero de configuración el tamaño de cada una de las columnas que lo componen. p.e.. col1=10, col2=100, col3=200. Al finalizar el browse grabo en ese fichero de configuracion el tamaño que tienen al final, por lo que si se cambio el ...
by miarcod
Sat Jun 30, 2012 6:38 pm
 
Forum: FiveWin para CA-Clipper
Topic: pantalla ampliada
Replies: 1
Views: 1359

Re: xBrowse y SetArray(aArray) (SOLUCIONADO)

Estimados

El ejemplo que propone Daniel sale una columna fantasma "Col1", a mi una columna "A"
como se soluciona esto?
by Patricio Avalos Aguirre
Fri Oct 08, 2010 8:14 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: xBrowse y SetArray(aArray) (SOLUCIONADO)
Replies: 12
Views: 3946

Re: 10.3 xBrowse date display error

Rao, If we use the syntax, XBROWSE .... COLUMNS 'col1', 'col2' ... ALIAS <calias> or OBJECT <dataobj>, Can you explain in more detail about using the OBJECT clause, perhaps by providing an example. I am particularly wondering about how ...
by nageswaragunupudi
Wed Mar 31, 2010 7:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: 10.3 xBrowse date display error
Replies: 14
Views: 4593

Re: 10.3 xBrowse date display error

Rao, If we use the syntax, XBROWSE .... COLUMNS 'col1', 'col2' ... ALIAS <calias> or OBJECT <dataobj>, Can you explain in more detail about using the OBJECT clause, perhaps by providing an example. I am particularly wondering about how ...
by James Bott
Wed Mar 31, 2010 5:11 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: 10.3 xBrowse date display error
Replies: 14
Views: 4593

Re: 10.3 xBrowse date display error

... be out of place to mention a few hints to take the best advantage of XBrowse's built-in capabilities. If we use the syntax, XBROWSE .... COLUMNS 'col1', 'col2' ... ALIAS <calias> or OBJECT <dataobj>, XBrowse extracts the exact information about the datatype, datalen and datadec from ...
by nageswaragunupudi
Wed Mar 31, 2010 3:52 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: 10.3 xBrowse date display error
Replies: 14
Views: 4593
Next

Return to advanced search