How to fetch row at given index from QSqlQuery

Question

I am learning QT and using QSqlQuery to fetch data from database.

I have read this documentation. I know using next() function we can iterate through rows of QSqlQuery and using value(int col) function we can get data from current row.

But i dont know how to fetch row at particular index without using next() function.

Bowdzone · Accepted Answer · 2014-10-27 09:47:19Z

1

I did not use QSqlQuery so far myself but from the documentation the seek method seems suitable to me:

bool QSqlQuery::seek ( int index, bool relative = false )

"Retrieves the record at position index, if available, and positions the query on the retrieved record. [...]"

answered Oct 27, 2014 at 9:47

Bowdzone

3,87511 gold badges42 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Harikesh Over a year ago

Yes i just found same solution myself. Actually i did not given too much attention to seek method because it returned bool. But when i went through doc again i found that seek method not only returns bool but also shifts cursor position at given index. Thanks anyway i will accept your answer.

Collectives™ on Stack Overflow

How to fetch row at given index from QSqlQuery

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related