Please Explai Liuz,
I don't follow :)

>Luiz Alves wrote:
>
> Because T2 always will be greater than T1.

ALTER PROCEDURE TEST
RETURNS ( T1 TIMESTAMP
, T2 TIMESTAMP )
AS
BEGIN
T1 = CURRENT_TIMESTAMP;
T2 = T1 // T2 = T1

WHILE (T1 >= T2) DO // T2 still = T1
T2 = CURRENT_TIMESTAMP; // Now T2 should become greater / later
// than T1 and the WHILE should exit

SUSPEND; // T1 should be 1 measurable time unit
END // less than T2 on suspend ?

================================================================

>
> Luiz.
>
> ----- Original Message -----
> From: <hans@...>
> To: <ib-support@yahoogroups.com>
> Sent: Saturday, August 25, 2001 3:31 PM
> Subject: [ib-support] TimeStamp
>
> > Question,
> >
> > Why does the next procedure never exit ?
> >
> > =================
> >
> > ALTER PROCEDURE TEST
> > RETURNS ( T1 TIMESTAMP
> > , T2 TIMESTAMP )
> > AS
> > BEGIN
> > T1 = CURRENT_TIMESTAMP;
> > T2 = T1
> >
> > WHILE (T1 >= T2) DO
> > T2 = CURRENT_TIMESTAMP;
> >
> > SUSPEND;
> > END
> >
> > ================
> >
> > Best Regards
> > Hans
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/