Set Filter Problem

sanjeevdalela
sanjeevdalela Member Posts: 45
edited 2008-04-30 in NAV/Navision Classic Client
I am Using Set filter Code Field
if field data include & or / etc. Character then Filter Fails So
Please Suggest me How to Filter the Data.

Thanks
Sanjeev Kumar Dalela
Technical Consultant
(Dataman Computer Systems P Ltd.)

Comments

  • kine
    kine Member Posts: 12,562
    try to use quotes around the value...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • sanjeevdalela
    sanjeevdalela Member Posts: 45
    I try with ' add but not Sucess


    Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Head","Product Group Master"."Product Group Head");
    Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Name","Product Group Master"."Product Group Name");

    Data in Product Group Name Give Another Solution
    Sanjeev Kumar Dalela
    Technical Consultant
    (Dataman Computer Systems P Ltd.)
  • kine
    kine Member Posts: 12,562
    If you are using code, than correct form of using SETFILTER is: 
    Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Head",'%1',"Product Group Master"."Product Group Head");
Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Name",'%1',"Product Group Master"."Product Group Name");

    In this case NAV will do all what you need...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • arindom
    arindom Member Posts: 52
    U can write u 'r code as in bellow then & and \ will work .

    Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Head",'%1',"Product Group Master"."Product Group Head");
    Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Name",'%1',"Product Group Master"."Product Group Name");
  • rajpatelbca
    rajpatelbca Member Posts: 178
    I think if you will put range values eg. A0001..A0004 then its not working. if i am wrong then correct me.
    Experience Makes Man Perfect....
    Rajesh Patel

Categories