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

Don't add SUSPEND - it's only needed for SELECTable stored procedures.

And colons ( : ) should be used in front of parameters and variable names
if you use them in SQL statements like in your procedure.

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."