Hello all!

I have a big table (over 50K rcords) that i have to load to the application interface (a grid).

Has you can see this number of records will ruin the application performance.

Is there any way of using a parameter on the SELECT FIRST clause. For example the sp that returns the records could have a parameter for the number of records to be returned. Something like this:

SELECT FIRST :number_of_record
*
FROM
table

I have tried this but i had no luck so far. The only way i found to do this is to use the parameter has a counter on loop that returns the records!

Any thoughts about this?
Thanks in advance!

Luis Semedo Duarte