You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Passing values from level0 to level1 using dynamic view

3 replies [Last post]
Guest's picture
Guest

can anybody explain that. how to pass values from level0 prompt to level 1 Grid using dynamic view in a page

Guest's picture
Guest (not verified)
Re: Passing values from level0 to level1 using dynamic view

Can u be alittle more specific about ypur requirement?

pplsft_dev's picture
pplsft_dev (not verified)
Re: Passing values from level0 to level1 using dynamic view

Yes you easily can. You are not very clear but still what i got from the information supplied the prompt is the dynamic view. If i am right, then u can create the dynamic view based on your prompt field(fieldlev0) and give it as the prompt of the field(fieldlev0). And then write
fieldlev0.sqltext=expandsqlbinds("ur sql fr prompt req with binds :1, :2,...",value1,value2...);
whereever required.(ie. fieldchange, prebuild...)
and then (if req on fieldchange of fieldlev0) u can write
&row= getlevel0()(1).getrowset(scroll.level1record)(1);
&row.level1record.field1.value=fieldlev0.value;
&row.level1record.field2.value=getfield(level0record.fieldlev0).getrelated(level1record.field2);
thn u can use sqlexec to fill in other values. Hope that was of some use.

pplsft_dev's picture
pplsft_dev (not verified)
Re: Passing values from level0 to level1 using dynamic view

getfield(level0record.fieldlev0).getrelated(level1record.field2);

level0record.fieldlev0 : can be from record as u need.