How do we pass values into QAD's browse/view maintenance ?

[DivyaRajesh]

Hello!!!

I have a customized program with a purchase order number and receiver number as input fields.
When the purchase order number is keyed in, a browse at the receiver field should display only the associated receivers (belonging to the purchase order) ... Any idea how this can be done??

Regards,
Divya

 

[mosfin]

you didn't specify your MFGPRO version, assuming you have eB2.1, where you can easily modify design of any browser,
use one of the global global variables (see mfdeclre.i) as your parameter
e.g: initialize [global_ref] with your PO# before the the input statement (UPDATE,SET,PROMT-FOR)
and in the browser design you can use [global_ref] in the query filter expression

 

[DivyaRajesh]

helloo....

Thanks for the reply.
I have a field lc_po with purchase order number and it is followed by lc_grn - receiver number.
Just before the update of lc_grn, I wrote assign global_ref = lc_po.

In the where clause of the browse maintenance also I use, prh_domain = global_domain and prh_nbr = global_ref....
The browse still does not work... Any idea where am I wrong??

Regards,
Divya.

 

[mosfin]

you have to show here your code fragment

 

[DivyaRajesh]

Dear Mosfin....... this is what I tried doing

program 1
----------------------------


{mfdeclre.i}


define variable lc_po like prh_nbr no-undo.
define variable lc_grn like prh_receiver no-undo.


form
lc_po colon 10
lc_grn colon 40 with frame a.


update lc_po with frame a.
assign global_ref = lc_po.


update lc_grn with frame a.


.......and then more things..
---------------------------------------------------


36.20.13 Browse Maintenance

Name: xx094
Description Term: RECEIPT_DETAIL
Receipt Detail
Power Browse: no
Look-up Browse: yes
View: prh_hist
Purchase Order Receipt History


Where:
prh_domain = global_domain and prh_nbr = global_ref
-------------------------------------------------------------


Regards,
Divya.

 

[mosfin]

check in the source file generated by this browser (should be xxlu094.p or xxbr094.p)
if there's also {mfdeclre.i}

 

[DivyaRajesh]

It is xxlu094.p since I am trying to create a look up browser...... This one also has a mfdeclre.i at the top.
There are no syntax errors, however the browse is empty.

Rgds,
Divya.

 

[mosfin]

are you sure MFG is using your xxlu094.p (instead of vanila) ?
when you press Ctrl-F on lc_grn field, what name do you see in lookup browse ?

 

[DivyaRajesh]

yes.... sure its using my browse program. though there is data that can be viewed in the browse, the browse comes empty...