--- src/ui/dlgTable.cpp.orig Fri Aug 8 10:14:02 2003 +++ src/ui/dlgTable.cpp Fri Aug 8 10:18:58 2003 @@ -298,6 +298,7 @@ wxString dlgTable::GetSql() { wxString sql; + wxString m_sql; wxString tabname=schema->GetQuotedFullIdentifier() + wxT(".") + qtIdent(GetName()); if (table) @@ -326,7 +327,7 @@ if (index >= 0) tmpDef.RemoveAt(index); else - sql += wxT("ALTER TABLE ") + tabname + m_sql += wxT("ALTER TABLE ") + tabname + wxT(" ADD COLUMN ") + definition + wxT(";\n"); } @@ -355,11 +356,11 @@ if (index >= 0) tmpDef.RemoveAt(index); else - sql += wxT("ALTER TABLE ") + tabname + m_sql += wxT("ALTER TABLE ") + tabname + wxT(" ADD"); AppendIfFilled(sql, wxT(" CONSTRAINT "), conname); - sql += wxT(" ") + definition + wxT(";\n"); + m_sql += wxT(" ") + definition + wxT(";\n"); } for (index=0 ; index < (int)tmpDef.GetCount() ; index++) @@ -377,6 +378,7 @@ sql += wxT("ALTER TABLE ") + tabname + wxT(" WITHOUT OIDS;\n"); } + sql += m_sql; } else {