| Tag Link | [Field_Name] | Category | Database |
|---|---|---|---|
| Type | Substitution | Source Available | No |
| Support | Preferred | Version | 2.5 |
| Change | Unchanged | Data Source | Any |
| Output Type | String | Security | None |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0, Lasso 3.x, Lasso 2.5 |
[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].
[Field_Name:
[Field_Name: Field Index]
[Field_Name: Field Index,
[Field_Name: Field Index,
| Optional Parameters | |
|---|---|
| Field Index | Specifies which field name should be returned. Ranges from 1 to the value of [Field_Name: |
| -Count | Returns the number of fields in the current result set. Cannot be used in concert with a field index. |
| -Type | Optional keyword returns the type of a field. The type will be text, number, or date. |
| -Protection | Optional keyword returns the protection status of a field (if supported by the data source). |
To return a list of all fields in a table:
Use the [Field_Name] tag. The following example uses a
[Inline:
[Loop: (Field_Name:
<br>[Field_Name: Loop_Count] ([Field_Name: Loop_Count,
[/Loop]
[/Inline]
<br>FIrst_Name (text)
<br>Last_Name (text)
<br>Phone_Number (text)
<br>Title (text)
<br>Sex (text)