Supplier Schedule Browse

[donaldhl]

I am trying to create a Browse in .NET 1.1 eB2.1 SP5 that joins the sch_mstr, the schd_det and the pod_det.

From the entity Diagram's I am trying to create a view where the joins are:

Seq 1
Table = sch_mstr
Join phrase
sch_domain = global_domian

Seq 2
Table = schd_det
Join phrase
schd_domain = sch_domain and schd_type = sch_type and schd_nbr = sch_nbr and schd_line = sch_line and schd_rlse_id = sch_rlse_id

Seq 3
Table = pod_det
Join phrase
sch_domain = pod_domain and sch_type = "4" and sch_nbr = pod_nbr and sch_line = pod_line

But I am getting this error box:

An error occurred in the browse server. Please contact your system administrator and have them examine the webspeed logs.
ERROR: xx083: unable to prepare query. Query string for each qaddb.sch_mstr (sch_domain = 'US') no-lock, each qaddb.schd_det where (schd_domain = sch_domain and schd_type = sch_type 1!2!3 and schd_nbr = sch_nbr and schd_line = sch_line and schd_rlse_id = sch_rlse_id)no_lock,(-1)
unable to understand after -- "schd_det where" .(247)(-1)
PREPARE Syntax is {FOR ! PRESELECT} EACH OF WHERE ... etc".(7324)(-1)

Does any one know what I could be doing wrong, or how to create a view of these 3 tables so my browse will work.

Thanks

 

[Kishor Chari]

First try with sch_mstr, then with sch_det finally with pod_det. What you have sent looks good. Trial & Error is best means.