LassoScript Utility
Basics Browse Detail


Tag Link [Table_RealName] Category Database
Type Substitution Source Available No
Support Preferred Version 6.0
Change Unchanged Data Source Any
Output Type String Security Tag
Implementation LCAPI Sets Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0


[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']


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.


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') + '`;']