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
[Inline:
[Found_Count]
[/Inline]
8