Subject Re: [firebird-support] Re: Optimizing a query
Author Pavel Menshchikov
Hello Myles,

MW> I want to be able to pass in these values as arguments to the stored proc,
MW> but I can't seem to get them working by referencing the input parameters in
MW> the query in the SP like so:
MW> SELECT FIRST :A_ROW_COUNT SKIP :A_POSITION .....
Try
SELECT FIRST (:A_ROW_COUNT) SKIP (:A_POSITION) .....


--
Best regards,
Pavel Menshchikov