Difference between revisions of "SET FIELDS"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET FIELDS=
 
 
 
==Class==
 
Fields and Records
 
 
 
 
==Purpose==
 
==Purpose==
 
Specify a list of fields that are accessible in a table
 
Specify a list of fields that are accessible in a table
Line 12: Line 5:
 
==Syntax==
 
==Syntax==
 
SET FIELDS TO <field list> | ALL
 
SET FIELDS TO <field list> | ALL
 +
 
SET FIELDS ON | OFF | (<expL>)
 
SET FIELDS ON | OFF | (<expL>)
  
  
 
==See Also==
 
==See Also==
SET VIEW, FIELD(), FCOUNT()
+
[[FCOUNT()]], [[FIELD()]], [[SET VIEW]]
  
  
Line 24: Line 18:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
use patrons index events
 
use patrons index events
 
set fields to date, event, name
 
set fields to date, event, name
 
set fields on
 
set fields on
list for date<=date()</pre>
+
list for date<=date()</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[Category:Set_Commands|FIELDS]]
 +
[[Category:Table Basics]]
 +
[[Category:Table Basics Set Commands]]

Latest revision as of 15:43, 23 November 2009

Purpose

Specify a list of fields that are accessible in a table


Syntax

SET FIELDS TO <field list> | ALL

SET FIELDS ON | OFF | (<expL>)


See Also

FCOUNT(), FIELD(), SET VIEW


Description

The SET FIELDS TO <field list> command defines a list of fields which are accessible from the currently selected table. The SET FIELDS TO ALL command allows all fields to be displayed. The <field list> is not used unless SET FIELDS is ON. The <field list> can only contain fields from the currently selected table. By default FIELDS is OFF, and all fields in the currently selected table are accessible.


Example

use patrons index events
set fields to date, event, name
set fields on
list for date<=date()


Products

Recital Server, Recital