RE: Informix under Window NT
WHERE monedaid = monedaid (?!)
Use different names for the variable and the column, you're
confusing the poor thing with a tautology
> -----Original Message-----
> From: Elsa Perales [SMTP:eperales@gint.com.mx]
> Sent: Monday, January 10, 2000 2:08 PM
> To: informix-list@iiug.org
> Subject: Informix under Window NT
>
> Hello:
>
> I'm working with Informix Dymanic Server 7.31 TC2 under Windows NT 4.0
> platform. (The informix version I've down loaded from the internet)
>
> I have this table
>
> CREATE TABLE moneda
> (monedaid serial,
> desc varchar(75),
> abreviatura char(5),
> clavedivisa char(3),
> statusid smallint)>
> I have a stored procedure like this:
>
> CREATE PROCEDURE updmoneda (monedaid integer, desc varchar(75),> abreviatura
> char(5), clavedivisa char(3), statusid smallint)
>
> UPDATE moneda SET descripcion = desc, abreviatura= abreviatura,> clavedivisa=
> clavedivisa, statusid= statusid WHERE monedaid = monedaid;
>
> END PROCEDURE;
>
> My problem is that when I execute the stored procedure insted o updating
> only the row that matches the Where clause, it upgrades the hole table.
> Could this be because I don't have a Final version of the product from
> Informix? or, I'm doing somthin wrong?
>
> If any one can help.. I'll appreciate.
> Thanks
>
>
> Elsa Perales
> Grupo Internacional de Tecnologia Sa de CV
> eperales@gint.com.mx
>
>