Hi,

If you want to return a resultset, you need a SELECTable procedure.

This is accomplished by filling return parameters and using SUSPEND
to notify the client that it can fetch rows as it needs.

You can also have a simple procedure that has output parameters -
take a look at the Language Reference for more information. Basics
are explained in there. Basically, it's filling parameters and use the
right component on your client side.

Also take a look at the EMPLOYEE demo database as it has some
examples on select-able procedures.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."




I am having some difficulties figuring out how to accomplish this : I want
to use a stored procedure to preform a Select distinct on a table in my
database. the problem is how to return the information to the calling
application (I read something about a select procedure, is this the only
possible way to achieve this?)

Thanks in advance,

Bert