Please enable JavaScript to view this site.

Navigation: » No topics above this level «

DAL method: TableName() (Deprecated)

Scroll Prev Next More

 

Deprecated

This function is deprecated, and we recommend using the DB API: PrepareSQL function to prepare complex queries.

 

Returns the table name. TableName() is used for complex queries with calculated fields or joined tables.

Syntax

TableName()

Arguments

No arguments.

Return value

Returns the table name.

Example

Using a complex query:

 

sql = "select sum(UnitsInStock) as total, concat(Category,' ',ProductName) as FullProductName from "
sql = sql & dal.Table("Products").TableName() & " group by country"

See also:

DAL Method: UsersTableName

DB API: PrepareSQL

Database API

About Data Access Layer