SETRANGE on GUID datatype field.

satish_nav

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..

einsTeIn.NET

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.

einsTeIn.NET

Record1.SETRANGE("Opportunity No",Record2."Opportunity No");

This should work anyway.