QSqlQuery select statment

[MrLibya]

hallo all
i will let the code talk

        QSqlQuery query;
        query.prepare("SELECT * FROM [main].[items] WHERE barcode = ? OR name = ? ");
        query.bindValue(0,ui->Numberinput->text());
        query.bindValue(1,ui->search_item->text());
        query.exec();
        query.first();
        ui->Cart->setItem(ui->Cart->currentRow(), ui->Cart->currentColumn(), new QTableWidgetItem(query.value(1).toString()));

the error i get

QSqlQuery::value: not positioned on a valid record

[raven-worx]

@MrLibya
are you sure that the query returns a valid result (QSqlQuery::isValid())?
Maybe you could iterate over the result and check it.

[MrLibya]

@raven-worx yes query.isValid() return false , will we don't really need that ! , i'm already know the query is not Valid , but how to write the correct syntax for this query

[raven-worx]

@MrLibya

qDebug() << query.lastError().text()

should give more hints whats the problem.

But i guess the problem is the table name ([main].[items]), which isn't valid?!?

[MrLibya]

@raven-worx ok i got

Parameter count mismatch

[MrLibya]

i also tried

        query.addBindValue(ui->Numberinput->text());
        query.addBindValue(ui->search_item->text());

but the same

[raven-worx]

@MrLibya
this error is very unspecific and may also occur when the query itself is invalid.
As i already stated, whats about the table name [main].[items]. Is this really correct?!

[MrLibya]

@raven-worx yep , i've already used this method in another function and it's work very well

void MainWindow::UpdateSearchItem(QStringList *List)
{
    QSqlQuery query("SELECT * FROM [main].[items]");
    while (query.next())
        *List << query.value(1).toString();
}

[hskoglund]

Hi, maybe the text substitution goes haywire, to see the resolved text, try:
qDebug() << query.executedQuery();

[MrLibya]

@hskoglund said in QSqlQuery select statment:

qDebug() << query.executedQuery();

i got

"SELECT * FROM [main].[items] WHERE barcode = ? OR name = ? "

[hskoglund]

Indeed the text substitution seems borked, you could try instead doing the text substitution directly yourself, something like this:

QSqlQuery query("SELECT * FROM [main].[items] WHERE barcode = '123' OR name = 'Smith'");

[MrLibya]

@hskoglund that will not really helps , goes the barcode - name , the user will input from line edit , so dose this only not work on sqlite ? if i use mysql it will work ??

[hskoglund]

Hi, you can build the select string something like this:

QString s = QString("SELECT * FROM [main].[items] WHERE barcode = '%1' OR name = '%2'").arg(ui->Numberinput->text()).arg(ui->search_item->text());
QSqlQuery query(s);

[MrLibya]

This post is deleted!

[MrLibya]

@hskoglund thx it work :)