printsqla($dbType, $sqla2);
}
}
if ($dbType == 'odbc_mssql') {
$dsn = $dsn = "PROVIDER=MSDASQL;Driver={SQL Server};Server=localhost;Database=northwind;";
if (@$db->Connect($dsn, "sa", "natsoft", "test")) {
}
$dict->SetSchema('');
$sqla2 = $dict->ChangeTableSQL('adoxyz', $flds);
if ($sqla2) {
printsqla($dbType, $sqla2);
}
}
adodb_pr($dict->databaseType);
printsqla($dbType, $dict->DropColumnSQL('table', array('my col', '`col2_with_Quotes`', 'A_col3', 'col3(10)')));
printsqla($dbType, $dict->ChangeTableSQL('adoxyz', 'LASTNAME varchar(32)'));
}
function printsqla($dbType, $sqla)
{
print "<pre>";
//print_r($dict->MetaTables());
foreach ($sqla as $s) {
$s = htmlspecialchars($s);
print "{$s};\n";
if ($dbType == 'oci8') {
print "/\n";
}
}
print "</pre><hr />";
}
/***
if (file_exists('d:\\inetpub\\wwwroot\\php\\phplens\\adodb\\adodb.inc.php')) {
if ($dbType == 'mysql') {
$db->Connect('localhost', "root", "", "test");
$dict->SetSchema('');
$sqla2 = $dict->ChangeTableSQL('adoxyz', $flds);
if ($sqla2) {
printsqla($dbType, $sqla2);
}
}
}
if ($dbType == 'postgres') {
$db->Connect('localhost', "tester", "test", "test");
$dict->SetSchema('');
$sqla2 = $dict->ChangeTableSQL('adoxyz', $flds);
if ($sqla2) {
printsqla($dbType, $sqla2);
}
}
}
function printsqla($dbType, $sqla)
{
print "<pre>";
//print_r($dict->MetaTables());
foreach ($sqla as $s) {
$s = htmlspecialchars($s);
print "{$s};\n";
if ($dbType == 'oci8') {
print "/\n";
}
}
print "</pre><hr>";
