Hello, Paul.

I don't have the MM 8.0 docs in front of me, but it looks as if you're missing the '?' to define vp_iLangID as a view parameter. Try it as:

CREATE SQL VIEW "LV_MSGSVCINIT" ;
AS SELECT * from msgsvc where ilangid = ?vp_iLangID OR (ilangid = 0 AND ckey NOT IN (SELECT ckey FROM msgsvc WHERE ilangid = ?vp_iLangID))

Hope that helps,
---J

>Hello,
>
>Just purchased the framework and try to set up a basis with multi-lingual support.
>Creating a new project with Qstart works fine. Also the rebuild etc.
>
>When following the steps on page 328 of DevGuide "Multi-Lingual Setup" the following message is given in langsetup.prg: SQL: Column 'VP_ILANGID' is not found.
>
>Do I make a mistake or is there an error in the setup procedure?
>
>Thanks in advance for the advice.
>Paul Petraeus.
>
>Below the code that is involved in langsetup.prg.
>
>FUNCTION MakeView_LV_MSGSVCINIT
>***************** View setup for LV_MSGSVCINIT ***************
>
>CREATE SQL VIEW "LV_MSGSVCINIT" ;
> AS SELECT * from msgsvc where ilangid = vp_iLangID OR (ilangid = 0 AND ckey NOT IN (SELECT ckey FROM msgsvc WHERE ilangid = vp_iLangID))