Subject Re: [firebird-support] Views and parameters
Author Tim
>But i need to return a set of records, not a single record.


This will return you a result set. That's what a "FOR SELECT .. INTO ..
SUSPEND" does. If there is more than one record with the same value for
"recordnumber", you will get more than one record returned. If only one
record has the search parameter, then only one record will be returned.

If you are using Delphi, remember to call this procedure using a TQuery
object, not a TStoredProcedure object.

For example :


You can test the output using IBConsole (or some similar) by entering the
same SQL as above.

will return all the records matching the search criteria.



[Non-text portions of this message have been removed]