Re: [Firebird-net-provider] Restricting number of records returned

[<car...@te...>]

Hello:

> I have a search screen (WinForm app) where I show the result in a 
> DataGrid. If the user enters some search criteria then the number of 
> records returned is  less. But if the user doesn't specify anything all 
> records are returned and this slows down the server. What I want to 
> achieve is to have some kind of paging so that the DataGrid fetches only 
> records it can show in grid and then  does another fetch when the user 
> scrolls.  Is it possible? If yes, could anyone point me in the right 
> direction.

I think you can try to do this using the FIRST/SKIP syntax of Firebird.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain