check out FetchAsNeeded in cursorsetprop(). You will not be able to share the connection of the view if you use it.


>Hi.
>
>I have a table in SQL Server with 200.000 records. I send a "Select" and the server returns 20.000 records. But this may cause a lot traffic. The question: Can it catch 50 registers each time of these 20.000 returned? In mySQL it has LIMIT clause but I did not find nothing similar in the SQL Server.
>
>[ ]'s
>
>Vinicius Ribeiro
>vinicius.listas@ig.com.br