| PHP |
|---|
|
public function LoadSQL(?LJCDbColumns $keyColumns = null , ?array $propertyNames = null, ?LJCJoins $joins = null , ?string $filter = null) : string |
| PHP |
|---|
// Creates the Load SQL.
private static function LoadSQL(LJCDataManager $manager)
{
$nameValue = "NameValue";
$methodName = "LoadSQL()";
$data = new LJCDbColumns();
$data->Add("Name", value: $nameValue);
$affectedCount = $manager->Add($data);
// Load with SQLLoad().
// See constructor for how to create $manager.
$keys = new LJCDbColumns();
$keys->Add("Name", value: $nameValue);
$result = $manager->LoadSQL($keys);
// result:
// $manager->SQL =
// select
// TableName.ID,
// TableName.Name
// from TableName
// where TableName.Name = 'NameValue'
$keys = new LJCDbColumns();
$keys->Add("Name", value: $updateValue);
$affectedCount = $manager->Delete($keys);
}
|