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>";