At 01:54 PM 03-10-01 +0100, Artur Anjos wrote:

>Did you read the manual? :)
>

You took the words right out of my mouth. :)

H.

>----- 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/
> >
> >
>
>
>
>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/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________