problem with FINDSET

vijay_g
vijay_g Member Posts: 884
Experts,
i am using FINDSET with a Recvar but before that i uesd SETCURRENTKEY to this Recvar.
after setcurrentkey i have written Recvar.Ascending(false);
i want records in Descending order but it's prompt me an error like..

"You can not use FINDSET with Rec.ascending false"

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    Did you read the help?

    FINDSET (Record)
    Use this function to find a set of records in a table based on the current key and filter. The records can only be retrieved in ascending order.
  • kriki
    kriki Member, Moderator Posts: 9,121
    So, this is a case where you need to use FIND('-').
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • vijay_g
    vijay_g Member Posts: 884
    kriki wrote:
    So, this is a case where you need to use FIND('-').

    thank's a lot.
  • kine
    kine Member Posts: 12,562
    Or question is, do you really need to go backward through the dataset? :wink:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.