void vendor::sPrevious() { XSqlQuery nextq; nextq.prepare("SELECT vend_id " " FROM vendinfo" " WHERE (:number > vend_number)" " ORDER BY vend_number DESC" " LIMIT 1;"); nextq.bindValue(":number", _number->text()); nextq.exec(); if (!nextq.first() && nextq.lastError().type() == QSqlError::NoError) { QMessageBox::information(this, tr("At First Record"), tr("You are already on the first record.") ); return; } else if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Vendor"), nextq, __FILE__, __LINE__)) return; int newid = nextq.value("vend_id").toInt(); if(!sCheckSave()) return; clear(); _vendid = newid; sPopulate(); }
void vendor::sPrevious() { // Find Next q.prepare("SELECT vend_id " " FROM vendinfo" " WHERE (:number > vend_number)" " ORDER BY vend_number DESC" " LIMIT 1;"); q.bindValue(":number", _number->text()); q.exec(); if(!q.first()) { QMessageBox::information(this, tr("At First Record"), tr("You are already on the first record.") ); return; } int newid = q.value("vend_id").toInt(); if(!sCheckSave()) return; clear(); _vendid = newid; populate(); }
void vendor::sNext() { XSqlQuery vendorNext; // Find Next vendorNext.prepare("SELECT vend_id " " FROM vendinfo" " WHERE (:number < vend_number)" " ORDER BY vend_number" " LIMIT 1;"); vendorNext.bindValue(":number", _number->text()); vendorNext.exec(); if(!vendorNext.first()) { QMessageBox::information(this, tr("At Last Record"), tr("You are already on the last record.") ); return; } int newid = vendorNext.value("vend_id").toInt(); if(!sCheckSave()) return; clear(); _vendid = newid; sPopulate(); }