Subject | Re: [firebird-support] Re: Optimizing a query |
---|---|
Author | Pavel Menshchikov |
Post date | 2006-12-04T12:21:48Z |
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
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