-FindAll
The -FindAll command tag allows all records within a database table to be returned.
The database and table for the find all action should be specified using the -Database and -Table command tags.
- Syntax
- Parameters
[Inline: -FindAll,
-Database='Database_Name',
-Table='Table_Name', ...]Examples
To find all records within a database:
Use an [Inline] tag with a -FindAll command tag. The following example finds all records within the People table of the Contacts database.
[Inline: -FindAll,
-Database='Contacts',
-Table='People',
-KeyField='ID']
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]Result:
<br>John Doe
<br>Jane Doe
<br>John Person
<br>Mary Peoples
<br>Mark Surname
| Tag Link | -FindAll | Category | Action |
|---|---|---|---|
| Type | Command | Data Source | Any |
| Support | Preferred | Version | 2.5 |
| Output Type | None | Security | Database,Classic |
| Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x,LDML25 |
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