Hello, i´m a Clarion developer using Firebrid through odbc access,
(easysoft). We have a question i have no elements to answer and would
like to know.
When a query is sent to the server, it receives it, and if applicable,
dispatches it.
What happens with the number of records sent to the client ?
Eg: Select bla bla from mytable where condition_met , retrieves
let´s say 150 records.
In this case i want to "page" in 25 record pages.
Does the server sends all of such records or do i have to specify with
a "limit" clause the number of records i need at a time ?
Eg: Select bla bla from mytable where condition_met "limiting to 25"
Maybe there is a server setting to set to send "n" records at a time ?
Where can i find docs about such features ?
Thanks in advance.