Subject | Re: [ib-support] problem with very simple Stored Procedure |
---|---|
Author | Helen Borrie |
Post date | 2002-08-26T17:23:05Z |
At 03:45 PM 26-08-02 +0000, you wrote:
If so, try
update online_ set timeout = cast('NOW' as date);
-- heLen
>Hi,Is your DB Dialect 1?
>
>Here is my very simple SP:
>
>CREATE PROCEDURE SET_TIMEOUT
>AS
>begin
>update online_ set timeout = current_timestamp;
>end
>
>
>But Firebird 1.0 returns me this error:
>
>Statement #1:
>Unknown error.
>
>
>I doublechecked table "online_" and column "timeout" datatype is
>timestamp.
If so, try
update online_ set timeout = cast('NOW' as date);
-- heLen