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();
}
