Re: current function in long running strored procedure

Sorry, its a bug that's been there a long time, and there is no sane work around. (What I mean is theoretically, you could write a C program that would do it but it would be tooooo expensive...) In article <35A9E5C5.8DD6580E@procent.hu>, Wolf Peter <wolf.p@procent.hu> 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 > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum