$tbl = new Table($Server);
$tbl->setOwner($User);
$tbl->setName($Tablename);
if (!$tbl->Truncate()) {
$html .= "<P><B>Table truncating failed.</B></P>";
}
} elseif ($TRUNCATE == "no") {
$html .= "<P><B>Table truncating cancelled.</B></P>";
}
case "drop2":
$DROP = getData("DROP");
if ($DROP == "yes") {
$tbl = new Table($Server);
$tbl->setOwner($User);
$tbl->setName($Tablename);
if (!$tbl->Drop()) {
$html .= "<P><B>Table dropping failed.</B></P>";
}
} elseif ($DROP == "no") {
$html .= "<P><B>Table dropping cancelled.</B></P>";
}
default:
$html .= "<P>Execute SQL Statement:<br>" . "<form action=\"tbl_detail.php\" method=\"post\" enctype=\"application/x-www-form-urlencoded\">" . "<input type=\"hidden\" name=\"Tablename\" value=\"{$Tablename}\">" . "<input type=\"hidden\" name=\"Server\" value=\"{$Server}\">" . "<input type=\"hidden\" name=\"User\" value=\"{$User}\">" . "<input type=\"hidden\" name=\"mode\" value=\"main\">" . "<input type=\"hidden\" name=\"submode\" value=\"execute\">" . "<textarea name=\"statement\" cols=\"80\" rows=\"5\" wrap=\"VIRTUAL\" style=\"width: 400px\"></textarea><br>" . "<input type=\"Submit\" name=\"BUTTON\" value=\"Execute\">";
$html .= "</form></td></tr></table></p>";
}
// end submode content
break;
default:
}
// end switch mode
$page = new Page("Table Management - " . $User . "." . $Tablename);
