I don't see anithing wrong, but NOW is de full Time I means
(Day/Month/Year/Hour/Minute/Secund...)
I suppose "Term" not match with the full Date.

----- Original Message -----
From: "Andrew Guts" <andr@...>
To: "IB support" <ib-support@yahoogroups.com>
Sent: Tuesday, October 22, 2002 05:06 AM
Subject: [ib-support] Wrong codeflow in SP. Possible bug


> Hello IB support.
>
> This is a fragment of my stored proc. Qty is an integer parameter. The
> statement after "ELSE" is never executed. When I've replaced
> "ELSE" by "if (Qty <= 0) then" it works as expected. What is wrong with
it?
>
> if (Qty > 0) then
> if (exists (select docid from Closed_Docs where DocID = :d))
> then exception xcptdoc_closed;
> else
> if (exists (select DocRow from Reserves where DocRow = :DocRow
> and Term >= 'NOW' and AuthorID <> :E))
> then exception XCPT_RESERVED;
>
> Thanks ahead.
>
> Andrew
>
>
>
> 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/
>
>