Re: Form Properties. Range High Value

From: Paul Dorsey <DORSEY_at_ENIGMA.RIDER.EDU>
Date: Thu, 28 Dec 1995 07:48:50 -0400
Message-Id: <9512281340.AA21179@alice.jcc.com>

You have to trick it to do date comparisons. Try this in your trigger:

declare

        dif number;
begin
dif := :testdate - sysdate;

if dif < 0 then

        bell;
        message ('big');
else
        message ('small');

end if;
end;

Sorry, I thought you probably knew this trick. Paul Dorsey
Dulcian Inc. Received on Thu Dec 28 1995 - 08:40:30 CST