SETRANGE on GUID datatype field.

satish_nav
satish_nav Member Posts: 65
edited 2010-12-28 in NAV/Navision Classic Client
HI experts,

I have a field "Opportunity No" with data type GUID. I need to apply SETRANGE() on this opportunity field.
This field having 16byte encoded information like:{3749EB14-257B-DF11-0000-00219B942EBC}

Can i apply SETRANGE on this datatype field.
Ex: Record1.SETRANGE(Record1."Opportunity No",Record2."Opportunity No");

Please help me on this..
Thanks in advance..

Satish...

Comments

  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    edited 2010-12-28
    As far as I know GUID are displayed in a textual representation. So you probably just have to filter like you do on text fields. Give it a try.

    Edit: You have to filter on the whole GUID string. no wildcards, no question marks etc.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050 
    Record1.SETRANGE("Opportunity No",Record2."Opportunity No");
    This should work anyway.
    "Money is likewise the greatest chance and the greatest scourge of mankind."

Categories