Re: SQL Forms 3.0 -multiple records-

Thanks for the info I was able to get the multiple records. My only remaining question refers to a nondatabase field, say a value from another table to be placed in Block2. You mentioned using a POST QUERY, which I was able to use. The only problem is having it repeat for each record in Block2.

> >
> OK - I apologise as well.
>
> Here is your original query:
>
> SELECT EMPLOYEE, TO_CHAR(EMP_DATE,'MM/DD/YYYY'),
> TO_CHAR(EMP_DATE,'HH:MIAM'),
> PHONE,EMP_TYPE,COMMENTS1,COMMENTS2,COMMENTS3
> FROM EMP
> WHERE PHONE = :YYY_T0.PHONE;
>
> I think you want all these records to appear in block 2. Yes?
>
> If so, then block 1 ill be based on phone_call, and
> block2 will be based on EMP. Block 2 will be defined as
> displaying many rows. The default join condition will be
> where block2.phone=block1.phone.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 04:52:44 CEST