Re: [Firebird-fr-support] =?iso-8859-1?q?Comment_r=E9cup=E9rer_le_r?= =?iso-8859-1?q?=E9sultat_d=27un_SELECT_dans_une_proc=E9dure_stock=E9e=3F?=

[Philippe M. <mak...@fi...>]

Florian Champion a =E9crit :
> SET TERM ^ ;
> ALTER PROCEDURE MESSAGE_BAD_FUNCTION_ALERT (
>    FUNCTION_NAME Varchar(30) )
> RETURNS (
>    MESSAGE_TEXT Varchar(100) )
> AS
> BEGIN
>    SELECT MESSAGE_TEXT FROM MESSAGES_FOR_HARMFUL_FUNCTIONS
>        WHERE FUNCTION_NAME =3D :FUNCTION_NAME INTO MESSAGE_TEXT;
> END^
> SET TERM ; ^
>=20
>=20
> L=E0 encore, le r=E9sultat du SELECT n'est pas contenu dans MESSAGE_TEX=
T.=20
> Pourtant ce SELECT me retourne bien ce que je cherche, mais il ne met=20
> pas son r=E9sultat dans la variable.
>=20
> Comment faire?
> Je vous serais tr=E8s reconnaissant de m'indiquer vos remarques et id=E9=
es=20
> concernant ce probl=E8me.
>=20
en =E9crivant :
SET TERM ^ ;

ALTER PROCEDURE MESSAGE_BAD_FUNCTION_ALERT ( FUNCTION_NAME Varchar(30) )

RETURNS (  MESSAGE_TEXT Varchar(100) )
AS
BEGIN
      SELECT MESSAGE_TEXT FROM MESSAGES_FOR_HARMFUL_FUNCTIONS
          WHERE FUNCTION_NAME =3D :FUNCTION_NAME INTO MESSAGE_TEXT;
  SUSPEND;
END^
SET TERM ; ^

et ensuite :
SELECT MESSAGE_TEXT FROM MESSAGE_BAD_FUNCTION_ALERT;


--=20
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
Firebird serveur SQL open-source http://firebird-fr.eu.org