Re: Current function does not work!

Wolf Peter wrote: > > 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. CURRENT is set when the SPL is first started. It is not updated for the duration on the SPL. If you need the 'real' time you'll need to drop to the OS to get it. -- Paul Watson # WF Software Ltd # I don't suffer from Tel +44 1436 674729 # stress I'm a carrier Fax +44 1436 678693 #