Re: where clause

[Arjan Hoornstra <ahoor@YAHOO.COM>]

Heba,

1. The != means 'not equal to'. So the column value of ddl_item_numeber
must not be a dot to be selected.

2. As you can see in the code you suplied, There is a string
&item_count after the count(ddl_item_number). This means the value of
this count is stored in a variable called &item_count. In the where
clause is the &hdr_op_number a variable which must have been filled in
a previous query. In sqr there are different types of variables:
#variable for integer and decimal values
$variable for character and date values
&variable for all types which are filled from a column in a select
statement.

Hope this helps...

Arjan




--- Soliman Heba Contr <Heba.Soliman@FSCNET.VANDENBERG.AF.MIL> wrote:
> Hello all,
> I have 2 questions:
> 1-) What ddl_item_number != '.' mean in the where clause ?
> 2-) hdr_op_number is in a different table.  How come ddl_op_number =
> &hdr_op_number in the where clause if there are not join for the
> table of
> ddl_op_number and a table for &hdr_op_number ?
>
>
> begin-select
> count(ddl_item_number) &item_count
>   print &item_count     (0,45,4)        edit 9999
> from ddl
> where ddl_op_number = &hdr_op_number
>   and ddl_item_number != '.'
> end-select
>
> Any help will be greatly appreciated.
> Thanks,
> Heba


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/