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.

What is the table DDL?

Did you try a colon ( : ) in front of the parameter name:

WHERE USERNAME = :In_UserName;

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