don't use SUSPEND in this instance

> -----Original Message-----
> From: Luis Adrián Amato [mailto:amatoluis@...]
> Sent: Sunday, 30 November 2003 8:30 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] help Store Procedure
>
>
> Wrong ?
>
> CREATE PROCEDURE SP_INC (
> SUCUR INTEGER,
> INCREMENTO DECIMAL (2, 2))
> AS
> BEGIN
> if (incremento <> 0) then
>
> BEGIN
> UPDATE SUC_ART SET PRECIO=PRECIO*:INCREMENTO
> WHERE ID_SUC= :SUCUR ;
> SUSPEND;
> END
> END
>
> I must run a store procedure than update al the recordos from a
> SUCURSAL and increment the PRICE (PRECIO) with a PORCENT
> I don't know whats wrong with this?
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>