Re: Forms4.5 questions (passing parms betw/ forms & problem w/ select statements)

In article <4c18kk$5i7_at_hubcap.clemson.edu> powell_at_clemson.edu (Janice Powell) writes:
>I have 2 Forms4.5 questions.
>
>1) <snip>
>2)

If answers from the others in this thread don't help, maybe it is this:
If your order block is a multi-row block, then are you sure the current record in the block has the '040' value. You may be moving the cursor to a new row unintentionally. HTH, Steve Cosner

>I seem to be having a bit of difficulty using block items in the
>where clause of SELECT statements. For ex., I have an Order block that
>contains the item -- stock_num. I want to do a select statement to
>find all customers that purchased products where the stock number =
>'040'.
>If I execute the following statement
>select * from customer where customer.stock_num = :order.stock_num;
>I get no rows selected. But when I display the value of
>:order.stock_num it = '040' just as I expected it to.
>Then execute the following statement:
>select * from customer where customer.stock_num = '040';
>And I get the rows I expected. I'm puzzled, though, as to why I'm not
>getting anything when I use :order.stock_num in the 'where clause' of
>the select statement. Has anyone ever had this experience?
Received on Tue Jan 02 1996 - 00:00:00 CET