Re: Web PL/SQL module Master Context functionality

Is the module component called dept, or is this the table alias? In previous versions, I used a function to accomplish that:  FUNCTION
_CONTEXT(
  code IN titles.product_code%type )
  RETURN VARCHAR2 IS
    --
    --
    r_string VARCHAR2(100);
    select htf.header(3,title)
    into r_string
    from titles
    where product_code = code;
    return(r_string);
  END;
  --
This would be in a package (preference: PKGLST), and called in the User Help text, top of record list:
PAckage.GET_CONTEXT(P_<primary key column>);

-- 
Frank
<scotten_at_my-deja.com> schreef in berichtnieuws 8s6mm4$8ov$1_at_nnrp1.deja.com...


> Hi,

> 

> I'm trying to use the Master Context functionality of Designer 6i for


> generating a Web PL/SQL module and it does not seem to work.

> 

> In the Design Editor Online Help on Master Context it is explained that

> when you set Master Context preferences on the Module, then you should

> be able to reference items available in the master module component from

> the detail module component. It says that you are then able to

> reference master module componenent item values in LOVs, User Text, SQL

> expression unbound items, SQL text and user defined application logic.

> The format to use is 'module_component.item_name'.

> 

> I created the Dept Emp example (Dept = master). I set the preferences

> and tried to reference a master item from the Emp (detail module

> component) User text like this: htf.bold('department name: ' ||

> dept.dname).

> 

> I generated the module (no errors), but dept.dname did not contain any

> value, only the string 'department name' was displayed in bold.

> 

> What went wrong? This should work, right? Could anyone provide a working

> example of using Master Context functionality as explained in the Online

> Help?

> 

> Thanks in advance,

> 

> Sicco

> 

> 

> Sent via Deja.com http://www.deja.com/

> Before you buy.