Just add or expand a before insert and update trigger with

New.LastUpdated = Current_TimeStamp;

or add in in your procedure.

----- Original Message -----
From: "Richard" <RichardM@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, September 11, 2005 12:09 PM
Subject: [firebird-support] Getting stored procedure to obtain timestamp


> Hi,
>
> I have a stored procedure that updates a user record, and it works fine.
> I have a field in the user database that is called LastUpdated. What
> syntax would I use in the stored procedure, to get "it" to update the
> LastUpdated field in the users table, as opposed to me passing the
> LastUpdated time as a parameter?
>
> Thanks in advance
>
> --
> Richard
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>