--- In ib-support@y..., "custom_soft_sol" <jfischer@s...> wrote:

> --- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> > Hi,
> >
> > What makes you think it doesn't work? Doesn't it compile?
> > Doesn't it do the update? How are you executing it?
> >
>
> I get an error that says that the column LOGGEDINTIME does not

exist.

Now with the procedure below I get an error saying that In_UserName
does not exist???


create procedure UpdateUsers ( In_UserName VARCHAR(50) )
as
begin
UPDATE SYSUSERS
SET LOGGEDINTIME = CURRENT_TIMESTAMP
WHERE USERNAME = In_UserName;
SUSPEND;
end