void AreacodesCombobox::initializeFields()
{
setSelectedAreacode(blank);
setSelectedLocale(blank);
clear();
}
void AreacodesCombobox::on_returnPressed()
{
if ((aLocale.
trimmed().
length() >
1) && (aLocale
!= QString(selectedLocale
()).
toUpper())) {
QString searchText
= ("UCASE(locale) like '%");
searchText.append(aLocale.trimmed().toUpper());
searchText.append("%' order by LOCALE");
QString clause
= searchWordsClause
(aLocale,
"locale",
"AND",
false,
"locale");
clause.prepend("SELECT Areacode, Locale FROM AreacodesView WHERE ");
clause.append(" Order by Locale");
if (query.isActive()) // successful execution
{
if (query.size()==0)
{
tr
("No match found.\nCheck the spelling and try again."),
QMessageBox::Ok);
setFocus();
}
else
{
clear();
while (query.next())
{
QString locale
= query.
value(0).
toString();
addItem(locale);
}
if (query.size()==1)
else
{
// comboBox()->select(1, true);
}
}
}
else
{
}
// else if (model->query().isSelect()) // is a select statement
}
}
void AreacodesCombobox::initializeFields()
{
QString blank = " ";
setSelectedAreacode(blank);
setSelectedLocale(blank);
clear();
}
void AreacodesCombobox::on_returnPressed()
{
QString aLocale=currentText();
if ((aLocale.trimmed().length() > 1) && (aLocale != QString(selectedLocale()).toUpper()))
{
QString searchText= ("UCASE(locale) like '%");
searchText.append(aLocale.trimmed().toUpper());
searchText.append("%' order by LOCALE");
QString clause = searchWordsClause(aLocale, "locale", "AND", false,"locale");
clause.prepend("SELECT Areacode, Locale FROM AreacodesView WHERE ");
clause.append(" Order by Locale");
QSqlQuery query(clause);
if (query.isActive()) // successful execution
{
if (query.size()==0)
{
QApplication::beep ();
QMessageBox::warning(this, tr("Postcode Search"),
tr("No match found.\nCheck the spelling and try again."), QMessageBox::Ok);
setFocus();
}
else
{
clear();
while (query.next())
{
QString locale = query.value(0).toString();
addItem(locale);
}
if (query.size()==1)
QComboBox::setCurrentIndex(1);
else
{
// comboBox()->select(1, true);
QComboBox::showPopup();
}
}
}
else
{
QApplication::beep ();
QMessageBox::warning(this, tr("SQL Error"),
query.lastError().text(), QMessageBox::Ok);
}
// else if (model->query().isSelect()) // is a select statement
}
}
To copy to clipboard, switch view to plain text mode
Bookmarks