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.