Try using the litteral 'NOW'.

Regards,

Kiril.

--- In firebird-support@yahoogroups.com, Tope Akinniyi
<topeakinniyi@y...> wrote:

> Hi,
>
> I have this table schema for a test:
>
> CREATE TABLE "FIRST"
> (
> "ONE" VARCHAR(20),
> "TWO" TIME,
> "THREE" TIME,
> "FOUR" COMPUTED BY (three-two)
> );
>
> and this stored procedure:
>
> SET TERM ^ ;
> ALTER PROCEDURE FIRST1
> AS
> DECLARE VARIABLE i INTEGER;
> BEGIN
> i=0;
> WHILE (i<20000) DO
> BEGIN
> insert into first(one,two,three) values

('tt','12:00:00',CURRENT_TIME);

> i=i+1;
> END
> END^
> SET TERM ; ^
>
> On execution the column "THREE" that is supposed to contain the

varing CURRENT_TIME values have the same time for all the 20000
records. What am I doing wrong?

>
> Thanks for your enlightenment.
>
>
>
> -------
> Best regards,
>
> Tope Akinniyi
> CEO
> ShepherdHill Software
> Lagos, Nigeria
>
> Do not forget: Jesus said, I am the way, the truth and the life.
>
> Send instant messages to your online friends

http://uk.messenger.yahoo.com

>
> [Non-text portions of this message have been removed]