This list isn't for support questions.

Please feel welcome to join mailto:ib-support-subscribe@yahoogroups.com or
the InterBase list at www.mers.com.

Thank you.
Helen
(Moderator).

At 11:38 AM 27-01-01 +0000, you wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>
>- -----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Hello all,
>
>I was wondering how I can return a result set from a stored procedure?
>
>I need somthing like the following:
>
>
>CREATE PROCEDURE "retrieve_results" (UID INTEGER)
>AS
> RETURNS (results AS RESULTSET)
>BEGIN
> SELECT * FROM tbl_names WHERE uid = :uid;
>END;
>
>
>Any idea how I can do this?
>
>
>Thanks.
>
>
>Stephen.
>- -----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.0.4 (GNU/Linux)
>Comment: For info see http://www.gnupg.org
>
>iD8DBQE6cf+oPmm0AnNwb5MRAgu0AKCDXsFOY8WNQQgQy36RI5EWqpl/JgCePI0/
>YSBtMhmB3cvqssJswoaHKmg=
>=NUzY
>- -----END PGP SIGNATURE-----
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.0.4 (GNU/Linux)
>Comment: For info see http://www.gnupg.org
>
>iD8DBQE6crM8Pmm0AnNwb5MRAtSBAJ0d1M67MWbpHGtcm36ZWzYZx2ByFgCfXOjD
>il3gLU0PHOLPskImAZx3VZk=
>=zi1G
>-----END PGP SIGNATURE-----
>
>Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
>Shortcut URL to this page:
> http://www.onelist.com/community/IBDI

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________