Current function does not work!
Posted in 1998
Wolf Peter — — source: Informix-list mailing list archive (1991-1998)
HOW can I GET the real current time in stored procedure call?
These test program proofs that the built-in current function in a stored
procedure the procedure returns the time when the procedure BEGAN not
the CURRENT time!
create procedure test() returning datetime year to second;
define i int;
for i= 1 to 5
return current do with resume;
system( 'sleep 3' );
end for;
end procedure;
The execute procedure test()
returns
1998-07-13 11:33:53
1998-07-13 11:33:53
1998-07-13 11:33:53
1998-07-13 11:33:53
1998-07-13 11:33:53
Please send the answers to my e-mail and not only to the message group.