Lasso Soft Inc. > Home

[Table_RealName]

[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.

  • Syntax
  • Parameters
[Table_RealName: 'Database Name', 'Table Name']

[Table_RealName: 'Database Alias', 'Table Alias']
Required Parameters
Database Name The name of the database in which to search for the table name.
Table Name The table name or alias for which to return the real name.
Examples

To return the real name of a 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]
Result:
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. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft