-Show
The -Show command tag allows the schema of a database table to be displayed.
The database and table for the show action should be specified using the -Database and -Table command tags.
- Syntax
- Parameters
[Inline: -Show,
-Database='Database_Name',
-Table='Table_Name', ...]
<a href="default.lasso?-Show&
-Database=Database_Name&
-Table=Table_Name&...">Link</a>
<form action="default.lasso" method="POST">
<input type="hidden" name="-Show" value="">
<input type="hidden" name="-Database" value="Database_Name">
<input type="hidden" name="-Table" value="Table_Name">
...
<input type="submit" name="-Show" value="Show Schema">
</form>Examples
To show a list of all fields from a database table:
Use the -Show command tag in an opening [Inline] tag. The [Field_Name] tag will be used to loop through all the field names. The following example shows all field names from the People table of the Contacts database.
[Inline: -Show, -Database='Contacts', -Table='People']
[Loop: (Field_Name: -Count)]
<br>[Field_Name: Loop_Count]
[/Loop]
[/Inline]Result:
<br>First_Name
<br>Last_Name
<br>Title
<br>Sex
| Tag Link | -Show | Category | Action |
|---|---|---|---|
| Type | Command | Data Source | Any |
| Support | Preferred | Version | 3.0 |
| Output Type | None | Security | Database,Classic |
| Implementation | Internal | Sets | Lasso 6.0, Lasso 5.0,LDML3x |
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