fetch_by_id returns error(QSqlerror::type=4) when no data

[ledunkang]

My code likes this

Code: Select all

daoError = qx::dao::fetch_by_id(ap);
        bCommit = !daoError.isValid();

        if(!bCommit)
            qDebug() << "==> DaoErr Type: " << daoError.type();

If data exists, the (oci) query executes succesfully, while it returns error if no data exists and assert failed.
I don't think that sucess query without data queried shoud be regard as an sql error. Or I missed anything?

[qxorm]

Hi,

You are trying to fetch an item by id, so you know the id and you expect that the id exists in your database.
If not exists, there is something wrong, this is why QSqlError returns an error.

If you want to test it before fetching, just use qx::dao::exist() function.

[ledunkang]

Thanks, I'll try.