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.
[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>
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]
<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 | Sets | 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 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft