QSQL return multiple rows on a single fetch

[elicat]

Hi,

I am wondering if I can define a number of rows that can be returned on a single fetch when executing queries.

Please see the following for refrence: https://learn.microsoft.com/en-us/sql/odbc/reference/develop-app/rowset-size?view=sql-server-ver16

[JonB]

@elicat
Do you have evidence as to whether the QSQL code is already using such a parameter in its queries? Have you tried e.g. QSqlQueryModel::fetchMore()?

[SGaist]

Hi,

You can use the LIMIT clause in your query depending on what you want to achieve. It can help for doing paging.