Lasso Soft Inc. > Home

[ Column ]

Method

[Column] returns the value for a field from the current database search. This tag can be used within [Inline] containers that return a database found set or on the response page for a Classic Lasso database action that returns a found set.

The name of the field specified in the [Column] method must be defined in the current found set. If it is not then a syntax error will be reported.

Normally, the [Column] method is used within [Records] containers to return the field value from each record in the found set in turn. It can also be used outside of [Records] containers to return the field value from the first record in the found set (useful if there is only one record in the found set).

For FileMaker Pro databases, related field values can be returned by specifying the name of the relation followed by two colons and the name of the field, e.g. relation::fieldname. The related field value must be included in the current layout.

Accepts the standard encoding flags:
-encodeNone, -encodehtml, -encodeBreak, -encodeurl, -encodeStrictURL, -encodexml (note that -encodeSmart is no longer available)

Returns appropriately encoded field data.

  • Syntax
Column('Field_Name')

Records
	Column('Field_Name')
/Records

Records(-InlineName='Inline_Name')
	Column('Field_Name')
/Records

Column('Relation_Name::Field_Name')
	Portal('Relation Name')
	Column('Relation_Name::Field_Name')
/Portal
Examples
  • Beginner

To return field values from a search:

Use a [Column] method for each field within [Records] container. The following example finds all records in the People table of the Contacts database and returns the First_Name and Last_Name fields for each record in the found set.

Code

Inline(
	-Database='Contacts',
	-Table='People',
	-FindAll
)
	Records
		Column('First_Name') Column('Last_Name')
	/Records
/Inline

Recent Comments

No Comments found

Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft