Did you read the manual? :)

Artur Anjos

----- Original Message -----
From: "Robert F. Tulloch" <tultalk@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, October 03, 2001 1:51 PM
Subject: Re: [ib-support] Stored Proc Question


> Hi:
>
> Thanks for input. I did not think IF THEN ELSE was available with
> SP's in IB?
>
>
> > DO BEGIN
> > IF (:vrd = :param1) THEN BEGIN
> > UPDATE mempay2 SET renew_dues = :param2 WHERE id = :vid;
> > END
> > ELSE IF (:vrd = :param3) THEN BEGIN
> > UPDATE mempay2 SET renew_dues = :param4 WHERE id = :vid;
> > END
> > ELSE IF (:vrd = :param5) THEN BEGIN
> > UPDATE mempay2 SET renew_dues = :param6 WHERE id = :vid;
> > END
> > END
> > END
>
>
>
>
> > Maybe you have to select more fields from mempay2 and use them in the
> > WHERE clauses of the UPDATE statements, if id does not uniquely
> > identify rows in mempay2.
>
> I need the YEAR2 and the Id to uniquely identify the rows to update.
> That should be no problem though.
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>