Filtering records

bindumlhbindumlh Member Posts: 3
edited 2006-09-26 in Navision Attain
Hi all,

Can any one pls tell me how to filter records in a table in Navision based on starting record number and ending record number of the table

Comments

  • mihai.valceamihai.valcea Member Posts: 95
    F7 on that field you want to filter and enter starting number..ending number or 1..10000 by example.
    In C/AL use setrange.
  • krikikriki Member, Moderator Posts: 9,086
    If it is an integer, I would say:
    recYourTable.RESET;
    recYourTable.SETCURRENTKEY("Your Field"); // if the index exists and there isn't a better index.
    recYourTable.SETRANGE("Your Field",intStartRecordNo,intEndRecordNo);
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • bindumlhbindumlh Member Posts: 3
    Hi all

    Firstly Thank u for ur replies.
    But actually wat my query is I want the set of records not based on any fld in table.
    From dotnet i am calling a function in navision
    This func gets starting recno and ending no from dotnet
    ex: starting rec no 11
    ending rec no. 20
    for this i need to retrieve 10 records i.e., from 11 th rec to 20th rec.
    and return this data to dotnet.

    So can anyone tell me that is it possible to retrieve record number(position)
    from a table in navision so that i can setrange the record number according to my reqts.

    Thank u
  • krikikriki Member, Moderator Posts: 9,086
    From where come the recordnos?
    Navision doesn't have recordnos. Except some tables in which field "Entry No." is the primary key.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.