select statement

From: Martin Meadows <mmeadows_at_indy.net>
Date: Sun, 26 Apr 1998 18:48:02 -0500
Message-ID: <3543C7B2.27E2@indy.net>

Hi. I just saw the following select statement in a trigger step in sqlforms:

select 'X'
from dummy
where :ptm_check_# != 0

This was for a post-change trigger. I know that the dummy & the dual table are the same thing. I know that :ptm_check_# is the value of a field in the form that was/is provided by the user. So if :ptm_check_# = 0 nothing is selected ... right? And if :ptm_check_# != 0 then 'X' is selected ... but I don't see how it's used in this situation. What's the purpose?

Thanks,
Martin Meadows Received on Sun Apr 26 1998 - 18:48:02 CDT