It's ridiculous

Here is everything i typed. it looks EXACTLY like your code.

I don't understand. If you have any clue, please tell me. I am
beginning to think computers are against me! I even tested it in a
fresh new database file... same result. i am using firebird on win32,
dated march 12.

Thank you very much for your help.

S. Breton

----------------- starts here -----------------
create table online_ (timeout timestamp);

set term!!;
create procedure timeout
as
begin
update online_ set timeout = current_timestamp;
end!!

>>> DDL executed.
>>> Exec time: 0.00 s

commit;

>>> Exec time: 0.02 s

insert into online_ (timeout) values (current_timestamp);

>>> 1 row(s) inserted.
>>> Exec time: 0.00 s

update online_ set timeout = current_timestamp;

>>> PLAN (TIMEOUT_ NATURAL)
>>>
>>> 1 row(s) updated.
>>> Exec time: 0.02 s

Commit;

>>> Exec time: 0.00 s

Execute procedure timeout;

>>> Statement #1:
>>> Unknown error.

----------------- the end -----------------

--- In ib-support@y..., "Artur Anjos" <arsoft@n...> wrote:
>
> Hi Breton,
>
> It should work. That message should be from your client application.
>
> I have done this:
>
> create table online_ ( timeout timestamp );
> commit;
>
> SET TERM ##;
> CREATE PROCEDURE SET_TIMEOUT
> AS
> begin
> update online_ set timeout = current_timestamp;
> end ##
> SET TERM ; ##
> commit;
>
> /*Populate*/
> insert into online_ (timeout) values (current_timestamp);
> commit;
>
> execute procedure SET_TIMEOUT;
> commit;
>
> It worked ok, no errors at all.
>
> Artur
>