Section Access qvd field not found

[carolin01]

Hi,

I´m trying to load from a qvd to apply for a section access:

SECTION Access;

LOAD

  NTNAME,

     ACCESS,

  Upper(UserFullName) as UserFullName,

  upper(SoldToBusinessPartner.ExternalSalesRepName) as SoldToBusinessPartner.ExternalSalesRepName,

  upper(AreaSalesManagerName) as AreaSalesManagerName,

  upper(GeneralManagerName) as GeneralManagerName,

  upper(GlobalRegion) as GlobalRegion,

  upper(SheetFlagTest) as SheetFlagTest

FROM  $(vQVDPath)\SecurityFile.qvd (qvd)

where 1=1;

Section Application;

If I do this then it tells me that my first field is not found in the qvd although it is there and exists. What do I do wrong?

Many thanks in advance!

[swuehl]

Could you post the full error message QV is showing?

[carolin01]

[swuehl · Accepted solution]

I think you need to state the field names also in UPPER case, even when the source shows mixed or lower case field names:

SECTION Access;

LOAD

  NTNAME,

     ACCESS,

  Upper(USERFULLNAME) as USERFULLNAME,

  upper(SOLDTOBUSINESSPARTNER.EXTERNALSALESREPNAME) as SOLDTOBUSINESSPARTNER.EXTERNALSALESREPNAME,

  upper(AREASALESMANAGERNAME) as AREASALESMANAGERNAME,

  upper(GENERALMANAGERNAME) as GENERALMANAGERNAME,

  upper(GLOBALREGION) as GLOBALREGION,

  upper(SHEETFLAGTEST) as SHEETFLAGTEST

FROM  $(vQVDPath)\SecurityFile.qvd (qvd)

where 1=1;

[carolin01]

This is correct! 🙂 I also had to upper the fields in the connected tables and now it works. Many thanks!

[andrejfreitas]

Thank you!