Lasso Soft Inc. > Home

-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 2014 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft