This query runs fine in the SQLEditor in IBExpert. Are you saying it has to be in a Stored Procedure?

SELECT FIRST :Count *
FROM Table

--- In firebird-support@yahoogroups.com, "Luis Semedo Duarte" <CrazyMenConnected@...> wrote:
>
> 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
>