24,8 → 24,37 |
bool ModelForPointers::setData(const QModelIndex &index, const QVariant &value, int role) { |
//// if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå |
bool lResult = false; |
QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå |
old_value = data(index); |
|
if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ |
QSqlQuery qu; |
QString old_field_name; // ñòàðîå èìÿ ïîëÿ |
QString new_field_name; // íîâîå èìÿ ïîëÿ |
QString query_str; |
QString type_str; // òèï äàííûõ ïîëÿ |
old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ |
new_field_name = value.toString(); |
// type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå |
type_str = tr("CHAR(10)"); |
|
query_str = tr("ALTER TABLE "); |
query_str.append(ModelForPointers::Inctance); |
query_str.append(tr(" CHANGE COLUMN `")); |
query_str.append(old_field_name); |
query_str.append(tr("` `")); |
query_str.append(new_field_name); |
query_str.append(tr("` ")); |
query_str.append(type_str); |
query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL")); |
qu.prepare(query_str); |
bool ok; |
ok = qu.exec(); |
if (!ok) return false; |
} |
|
|
|
lResult = QSqlTableModel::setData(index, value, role); |
if (lResult) { |
QModelIndex newindex; |
36,6 → 65,7 |
|
|
lResult = updateRowInTable(index.row(), rec); |
emit field_changed(); |
/// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole); |
|
|