Difference between revisions of "FLDLIST()"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
(See Also)
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
 
==Purpose==
 
==Purpose==
 
Function to return a comma separated list of field names
 
Function to return a comma separated list of field names
 
  
 
==Syntax==
 
==Syntax==
 
FLDLIST([<workarea | alias>])
 
FLDLIST([<workarea | alias>])
 
  
 
==See Also==
 
==See Also==
[[ADESC()]], [[AFIELDS()]], [[DBF()]], [[FIELD()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[FMT()]], [[INDEXKEY()]], [[NDX()]], [[RTOS()]]
+
[[ADESC()]], [[AFIELDS()]], [[DBF()]], [[FIELD()]], [[FIELDNAME()]], [[FILTER()]], [[FLDCOUNT()]], [[INDEXKEY()]], [[NDX()]], [[RTOS()]], [[STR_QUOTEARGS()]]
 
+
  
 
==Description==
 
==Description==
 
The FLDLIST() function returns a string containing a comma separated list of field names.  The optional <workarea | alias> parameter can be used to operate on the table in the specified workarea number, or with the specified table alias.  If the optional <workarea | alias> is not specified, FLDLIST() operates on the currently selected table.  If there is no table selected or open with the specified alias name or in the specified workarea, FLDLIST() returns an error.
 
The FLDLIST() function returns a string containing a comma separated list of field names.  The optional <workarea | alias> parameter can be used to operate on the table in the specified workarea number, or with the specified table alias.  If the optional <workarea | alias> is not specified, FLDLIST() operates on the currently selected table.  If there is no table selected or open with the specified alias name or in the specified workarea, FLDLIST() returns an error.
 
  
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
procedure ExcelReport
+
open database southwind
  select * from example order by state save as datafile&(getpid())
+
use customers
  use datafile&(getpid()).dbf in 0
+
fieldList = fldlist()
  copy to datafile&(getpid()).txt type delimited
+
  fieldList = fldlist()
+
  use
+
  select example
+
  showDocument("DemoReportData.xls?command=create;row=3;col=1;"+;
+
    "title=<Demo Excel Report>;titleColor=23;columnTitles=&fieldList;"+;
+
    "columnTitlesColor=24;stripeColor=20;subtotal=8;"+;
+
    "subtotalcolumns=10,11,12;"+;
+
    "columnFormat=|||||||||$#,##0.00|$#,##0.00|$#,##0.00||;"+;
+
    "subtotalBackColor=24;subtotalForeColor=55;"+;
+
    "subtotalTitle=Sub-total for state: ","_blank", "datafile&(getpid()).txt")
+
endproc
+
 
</code>
 
</code>
 
+
 
+
==Products==
+
Recital Server, Recital
+
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Table Basics]]
+
[[Category:Cursor Functions]]
[[Category:Table Basics Functions]]
+

Latest revision as of 11:27, 12 May 2021

Purpose

Function to return a comma separated list of field names

Syntax

FLDLIST([<workarea | alias>])

See Also

ADESC(), AFIELDS(), DBF(), FIELD(), FIELDNAME(), FILTER(), FLDCOUNT(), INDEXKEY(), NDX(), RTOS(), STR_QUOTEARGS()

Description

The FLDLIST() function returns a string containing a comma separated list of field names. The optional <workarea | alias> parameter can be used to operate on the table in the specified workarea number, or with the specified table alias. If the optional <workarea | alias> is not specified, FLDLIST() operates on the currently selected table. If there is no table selected or open with the specified alias name or in the specified workarea, FLDLIST() returns an error.

Example

open database southwind
use customers
fieldList = fldlist()