[Table_RealName] returns the real name of the table passed as a parameter. This tag also requires a database parameter which specified the database in which to look for the table. If the parameter names a Lasso table alias then the original name of the table on the database server will be returned.
This tag can be used so the true name of a table can be used in SQL statements.
If the table name is not found then the specified name will be returned unchanged.
[Table_RealName: 'Database Name', 'Table Name']
[Table_RealName: 'Database Alias', 'Table Alias']
Use the [Table_RealName] tag. In the following example a table 'People' has been set up in Lasso Administration with an alias 'MyPeople'. The real table name must be used in the -SQL statement.
[Inline: -Database='MyContacts', -SQL='SELECT * FROM `' + (Database_RealName: 'MyContacts') + '`.`' + (Table_RealName: 'MyPeople') + '`;']
[Found_Count]
[/Inline]
8
Tag Link | [Table_RealName] | Category | Database |
---|---|---|---|
Type | Substitution | Data Source | Any |
Support | Preferred | Version | 6.0 |
Output Type | String | Security | Tag |
Implementation | LCAPI | Sets | Lasso 7.0, Lasso 6.0 |
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