Re: select statement

Martin,

The syntax you list here is often used in a "WHERE EXISTS" section of a query. In this situation, the execution of a higher level SQL query is likely dependent upon whether or not :ptm_check# is 0. If it is not 0, then the higher level query will execute.

--brad

Martin Meadows wrote:

> 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 Mon Apr 27 1998 - 10:41:36 CDT