SETFILTER Command for German Language

jnario
jnario Member Posts: 21
edited 2007-10-26 in NAV/Navision Classic Client
I have created a report which run perfectly in English Language, but when I switch the Language to German I'm getting below error message:

"Die Wahlöglichkeit 'Order' ist nicht vorhanden.
Die Wahlmöglichkeiten sind:

Angebot, Auftrag, Rechung, Guntschrift, Rahmenauftrag, Reklamation"

When I run the debugger, the problem is coming from below code:

SalesHdr.SETFILTER("Document Type",'Order');
PurchHdr.SETFILTER("Document Type",'Order');

Please advise correct syntax so I can execute in German language.

Thanks

Joel

Comments

  • stryk
    stryk Member Posts: 645
    jnario wrote:
    SalesHdr.SETFILTER("Document Type",'Order');
    PurchHdr.SETFILTER("Document Type",'Order');

    "Option" fields are internally saved as Integer. As you see, it is possible to have an imlicit conversion from textual expression into the numeric value, but the "Text" is according to the language layer.

    You should change the code into this:
    SalesHdr.SETRANGE("Document Type", SalesHdr."Document Type"::Order);
PurchHdr.SETRANGE("Document Type", PurchHdr."Document Type"::Order)

    This should solve the problem.

    Regards,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • jnario
    jnario Member Posts: 21
    Thank you very much. It works.

    Your'e help is very much well appreciated.

    Great website.

Categories