[ field_name ]
[Field_Name] returns the name of a field in the current database and table. A number parameter returns the name of the field in that position within the current table. Other parameters are described below. Synonym is [Column_Name].
- Syntax
field_name(Count)
field_name(field_index::integer)
field_name(field_index::integer, -type)Examples
- Beginner
To return a list of all fields in a table:
Use the [Field_Name] method. The following example uses a -Show action in an inline to return information about the People table of the Contacts database. The [Field_Name] method is used in [Loop] code blocks to return the names and types of the fields.
Code
inline(-Database='Contacts', -Table='People', -Show)
loop(Field_Name(Count))
Field_Name(Loop_Count)+' ('+Field_Name(loop_Count, -Type)+')<br>'
/loop
/inline
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 | Privacy | Legal terms and Shipping | Contact LassoSoft
Recent Comments