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]