Subject Re: [firebird-php] php/stored procedure error
Author Dmitry Kalugin
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;
Ac> SUSPEND;
Ac> end

Ac> ... then, whenever I run this sql command in PHP:

Ac> SELECT * FROM DELETE_PROPERTY WHERE the_property_id = 12
^^^
|||not right
right is:
execute procedure DELETE_PROPERTY(12)

--
Best regards,
Dmitry Kalugin
Ukraine, Donetsk