Sub select with multiple fields

building semantic layer
1

Hi

I am trying to translate the following sql into BO

select * from sudba04_svc
where
(dealer_code,service_code)
in
(select dealer_code,service_code
from sudba05_prt
where dealer_code = ‘08596’
and part_no = ‘82’–This is going to
be a prompt–);

Please let me know if you have any ideas or suggestions?

Thanks for your help

Harpreet

Listserv Archives (BOB member since 2002-06-25)

2

In a message dated 00-04-03 11:49:57 EDT, you write:

I am trying to translate the following sql into BO

select * from sudba04_svc
where
(dealer_code,service_code)
in
(select dealer_code,service_code
from sudba05_prt
where dealer_code = ‘08596’
and part_no = ‘82’–This is going
to
be a prompt–);

Since BusObj only allows single value (object) sub-queries to be generated on the query panel, you will have to take this and create a predefined condition. In other words, take this:

(dealer_code,service_code) in
(select dealer_code,service_code
from sudba05_prt
where dealer_code = ‘08596’
and part_no = @prompt(‘Enter Part Number’,) )

… and put it in a predefined condition. Of course, you should use fully qualified column names in your code (meaning TABLE_NAME.COLUMN_NAME, not just COLUMN_NAME).

Having this in a predefined condition means that the user can simply select this condition any time this logic is required.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)