Loading...
 

DAL method: TableName()

Returns the table name. This function is used for complex query with calculated fields or joined tables.
Syntax
TableName()
Arguments
No arguments.
Return value
Returns the table name.
Example
Using complex query:
PHP
global $dal;
$tblProducts = $dal->Table("Products");
$sql = "select sum(UnitsInStock) as total, concat(Category,' ',
  ProductName) as FullProductName from ";
$sql .= $tblProducts->TableName() . " group by country";
ASP
sql = "select sum(UnitsInStock) as total, concat(Category,' ',ProductName) as FullProductName from "
sql = sql & dal.Table("Products").TableName() & " group by country"

See also