Parameters
$tableName - The table name.
$keyColumns - The where clause key columns.
Returns
The Update SQL statement.
Syntax
| PHP |
|---|
public static function CreateDelete(string $tableName
, LJCDbColumns $keyColumns) : string
|
Creates a Delete SQL statement.
Example
| PHP |
|---|
$webCommonPath = "c:/inetpub/wwwroot/LJCPHPCommon";
require_once "$webCommonPath/LJCDataManagerLib.php";
require_once "$webCommonPath/LJCDBAccessLib.php";
$keyColumns = new DbColumns();
$keyColumns->Add("ID", value:1);
$sql = LJCSQLBuilder::CreateDelete("TableName", $keyColumns);
// $sql =
// delete from TableName
// where TableName.ID = 1
|
Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.