Le 09/12/2004 11:15, Dmitry Kalugin a dit :

> Hello, ArnoldGamboa.com!
>
> Ac> I'm a Firebird newbie, so please bear with me :-)
> Ac> I tried a stored procedure
> Ac> CREATE PROCEDURE DELETE_PROPERTY (THE_PROPERTY_ID INTEGER)
> Ac> AS
> Ac> begin
> Ac> DELETE FROM PROPERTY_STYLE WHERE property_id = :THE_PROPERTY_ID;
> Ac> DELETE FROM PROPERTY_FEATURES WHERE PROPERTY_ID = :THE_PROPERTY_ID;

you don't need the line :

> Ac> SUSPEND;

You don't return anything so don't need SUSPEND

--
Philippe Makowski

Firebird serveur SQL open-source en français http://firebird-fr.eu.org

Ma clé PGP : http://makowski.eu.org/pgpkey.html