QSqlQuery::isValid returns false

[mismael85]

excuse me but i dont know how to enable the console.
i am using visual studio 2005.
i hope, i am not wasting your time.
but i believe if i want to learn some thing i must start my project directly as sayed in Qt documentation .but on the road there are missed things.
thank you

[wysota]

If you're using a commercial licence then access your project options using the integration plugin and it should be there somewhere. If not, run your application from within VS debugger and it should display the message. As an alternative, prepare a small qmake project and include a CONFIG+=console line in it.

[mismael85]

i made as you said and i get the following output:
1
QSqlQuery::value: not positioned on a valid record

[wysota]

How many records does the table hold?

[mismael85]

i tried it with two databases
one of them contains three records
and the other one contains 90 records.

[wysota]

Could you prepare a minimal compilable example reproducing the problem?

[mismael85]

here, it is the source code .
http://www.filesend.net/download.php...df51c62f649b7c

please dont forget to put the sample database in the ( c:\ ) directory.
the database are contained in the Zip file and also the *.pro file.

[mismael85]

i tried the same code with Sqlite database and the program works fine.
but why does not it work with MS access?

[wysota]

As I (think I) already said, maybe Access only supports sequential access to data.

[mismael85]

do you mean that i can not deal with access databases with Qt?

[wysota]

No, I mean Access databases can't jump across the result set regardless if you use Qt or not. If you want to reach the last entry, you have to iterate each record one by one until you reach the end.

[mismael85]

but i have the program that deal with access database which is built using visual basic
and this program go through the database easy it make last , first, next and previous
and i want to rebuild this program using c++. it means that the database support non sequential access
as well as sequential.