71,7 → 71,7 |
bool ok; |
ok = qu.exec(); |
if (!ok) return false; |
|
} |
/* |
if (!ok) { |
|
91,9 → 91,9 |
// rec.setGenerated(index.column()+2, true); |
// newindex = MyModel::index(index.row(), index.column()+2); |
// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole); |
} |
|
|
|
/* |
|
if (index.column()==0){ |
106,6 → 106,12 |
|
if (index.column()==3){ // åñëè ïîìåíÿëñÿ òèï äàííûõ |
///ALTER TABLE `an_db`.`1_Inctance` MODIFY COLUMN `int` INTEGER; |
|
bool ok; |
ok = setData(ModelForDescriptionTable::index(index.row(), 4), QVariant(tr("NULL")), Qt::EditRole); // ñáðîñèì çíà÷åíèå ïî óìîë÷àíèþ |
if (ok) { |
|
|
QSqlQuery qu; |
QString old_type, new_type, field_name, query_str; |
old_type = old_value.toString(); // îïðåäåëèì òåêóùèé (êîòîðîå íóæíî ïîìåíÿòü) òèï ïîëÿ |
118,12 → 124,12 |
query_str.append(tr("` ")); |
query_str.append(new_type); |
qu.prepare(query_str); |
bool ok; |
|
ok = qu.exec(); |
if (!ok) return false; |
else setData(ModelForDescriptionTable::index(index.row(), 4), QVariant(tr("NULL")), Qt::EditRole); // ñáðîñèì çíà÷åíèå ïî óìîë÷àíèþ |
} |
|
else return false; |
} |
if (index.column()==4){ // åñëè ïîìåíÿëîñü çíà÷åíèå ïî óìîë÷àíèþ |
///ALTER TABLE `an_db`.`2_Inctance` MODIFY COLUMN `Îò÷åñòâî` CHAR(10) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT 'Èâàíîâè÷'; |
QSqlQuery qu; |