Mercurial > hg > syntilista

comparison src/editperson.cpp @ 255:55581d90c55d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Change API for slCheckAndReportSQLError().
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 10 Oct 2018 13:21:51 +0300
parents 43a5e09bb832
children df3f902588af
comparison
equal deleted inserted replaced
254:0e0ad52994ca 255:55581d90c55d
106 person.addBindValue(selPerson.id); 106 person.addBindValue(selPerson.id);
107 person.addBindValue(selPerson.firstName); 107 person.addBindValue(selPerson.firstName);
108 person.addBindValue(selPerson.lastName); 108 person.addBindValue(selPerson.lastName);
109 person.exec(); 109 person.exec();
110 110
111 slCheckAndReportSQLError("SELECT check for existing person by same name (UPDATE)", person.lastError()); 111 slCheckAndReportSQLError(person, "SELECT check for existing person by same name (UPDATE)");
112 112
113 if (person.next()) 113 if (person.next())
114 { 114 {
115 // There exists another person with that name 115 // There exists another person with that name
116 slErrorMsg( 116 slErrorMsg(
137 person.prepare("SELECT * FROM people WHERE first_name=? AND last_name=?"); 137 person.prepare("SELECT * FROM people WHERE first_name=? AND last_name=?");
138 person.addBindValue(selPerson.firstName); 138 person.addBindValue(selPerson.firstName);
139 person.addBindValue(selPerson.lastName); 139 person.addBindValue(selPerson.lastName);
140 person.exec(); 140 person.exec();
141 141
142 slCheckAndReportSQLError("SELECT check for existing person by same name (ADD)", person.lastError()); 142 slCheckAndReportSQLError(person, "SELECT check for existing person by same name (ADD)");
143 143
144 if (person.next()) 144 if (person.next())
145 { 145 {
146 // There exists a record with same name 146 // There exists a record with same name
147 slErrorMsg( 147 slErrorMsg(
229 229
230 QSqlQuery query; 230 QSqlQuery query;
231 query.prepare(QStringLiteral("SELECT id,value,added FROM transactions WHERE person=? ORDER BY added DESC")); 231 query.prepare(QStringLiteral("SELECT id,value,added FROM transactions WHERE person=? ORDER BY added DESC"));
232 query.addBindValue(pinfo.id); 232 query.addBindValue(pinfo.id);
233 query.exec(); 233 query.exec();
234 slCheckAndReportSQLError("SELECT transactions for tableview_Transactions", query.lastError()); 234 slCheckAndReportSQLError(query, "SELECT transactions for tableview_Transactions");
235 235
236 model_Transactions->setQuery(query); 236 model_Transactions->setQuery(query);
237 237
238 model_Transactions->setHeaderData(0, Qt::Horizontal, tr("ID")); 238 model_Transactions->setHeaderData(0, Qt::Horizontal, tr("ID"));
239 model_Transactions->setHeaderData(1, Qt::Horizontal, tr("Summa")); 239 model_Transactions->setHeaderData(1, Qt::Horizontal, tr("Summa"));