do you know how to check if a record exist in qt ?..

[firesh]

do you know how to check if a record exist in qt ?..

what i would like to do is .. i listing all the members in a drop box which the names are from across 2 database tables ...

so i would like to check if this record exist in the first table .. else check in table 2.. then proceed to do something..

but i am stuck on how to check if a record exist in qt.. i am using sqlite.

[ChrisW67]

You execute a query looking for the record and see if it returns any rows. There is nothing Qt-specific about this.

bool ok;
bool foundBoth = false;
QSqlQuery q;
ok = q.exec("select 1 from table1 where field = value");
if (ok && q.next()) {
  ok = q.exec("select 1 from table2 where field = value");
  if (ok && q.next()) {
    foundBoth = true;
  }
}

bool ok;
bool foundBoth = false;
QSqlQuery q;
ok = q.exec("select 1 from table1 where field = value");
if (ok && q.next()) {
  ok = q.exec("select 1 from table2 where field = value");
  if (ok && q.next()) {
    foundBoth = true;
  }
}

To copy to clipboard, switch view to plain text mode 

Use bound parameters if there is any chance the value can be supplied directly by the user or contain semicolons, quotes etc. Heck, just use bound parameters anyway.