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 have the following SP that doesn't seem to want to work
>
> create procedure UpdateUsers ( In_UserName VARCHAR(50) )
> as
> begin
> UPDATE SYSUSERS
> SET LOGGEDINTIME = CURRENT_TIMESTAMP
> WHERE USERNAME = In_UserName;
> end
>
>
> If I run the Update by itself it works properly.
> What am I doing wrong.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."