Hello out there! I'm a bit of a newb in the realm of Progress programming and I have a question regarding the Browse-query functionality. From all the literature I have seen, it appears to me as if the query associated with a browse should only pull from 1 table, meaning that joins in a query are not really allowed. The program I am working with requires that I join multiple table to get all the fields I need to display in my browse. Here is my browse-query code:
open query q-order for each ld_mstr,
each so_mstr where so_mstr.so_nbr = ld_mstr.ldm_ord,
each cm_mstr where cm_mstr.cm_addr = so_mstr.so_cust,
each ccr_default where ccd_param = "CCR_CHEP" and
ccd_value = yes and ccd_cust = cm_mstr.cm_addr.
define browse brw-Order query q-order
display
ccr_default.ccd_param
ccr_default.ccd_value
so_mstr.so_cust
ld_mstr.ldm_nbr
ld_mstr.ldm_chep_outdt
with width 75 5 down title "Orders".
Is this correct or is there some other way to do joins in the query definition?
open query q-order for each ld_mstr,
each so_mstr where so_mstr.so_nbr = ld_mstr.ldm_ord,
each cm_mstr where cm_mstr.cm_addr = so_mstr.so_cust,
each ccr_default where ccd_param = "CCR_CHEP" and
ccd_value = yes and ccd_cust = cm_mstr.cm_addr.
define browse brw-Order query q-order
display
ccr_default.ccd_param
ccr_default.ccd_value
so_mstr.so_cust
ld_mstr.ldm_nbr
ld_mstr.ldm_chep_outdt
with width 75 5 down title "Orders".
Is this correct or is there some other way to do joins in the query definition?