Subject | Re: [firebird-php] php/stored procedure error |
---|---|
Author | Dmitry Kalugin |
Post date | 2004-12-09T10:15:10Z |
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
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