Hello,
i have a little problem...
i would like to make a database and add in the database a dynamic column...
the database have to look like this:
ID | File | Category | German
and when i click in my programm "add a new language" it have to look like this:
ID | File | Category | German | English
and so on...
the problem is, the first language is in the database and by the second language it creates only the column and put no data in the column...
for(i = m_Texte.TextMap.begin(); i != m_Texte.TextMap.end(); i++)
{
model.setTable("Texte");
model.select();
row = insertIndex.row() == -1 ? 0 : insertIndex.row();
model.insertRow(row);
// ID, File, Category, Language
record.setValue("ID", i->ID);
record.setValue("File", Datei);
record.setValue("Category", i->Kategorie);
record.setValue(Language, i->MapText[spr1]);
model.setRecord(row, record); // Record setzen
model.submitAll(); //
qDebug() << model.lastError();
}
model.select();
for(i = m_Texte.TextMap.begin(); i != m_Texte.TextMap.end(); i++)
{
QSqlTableModel model;
model.setEditStrategy(QSqlTableModel::OnManualSubmit);
model.setTable("Texte");
model.select();
QModelIndex insertIndex;
row = insertIndex.row() == -1 ? 0 : insertIndex.row();
model.insertRow(row);
QSqlRecord record = model.record(row);
// ID, File, Category, Language
record.setValue("ID", i->ID);
record.setValue("File", Datei);
record.setValue("Category", i->Kategorie);
record.setValue(Language, i->MapText[spr1]);
model.setRecord(row, record); // Record setzen
model.submitAll(); //
qDebug() << model.lastError();
}
model.select();
To copy to clipboard, switch view to plain text mode
when i click to add the new language, by "model.lastError()" i become an error:
The record could not be fetched! "constraint failed"...
does anybody know why i get this error?
kind regards
Bookmarks