Filtering records

Comments

• mihai.valcea Member Posts: 95

  2006-09-26

  F7 on that field you want to filter and enter starting number..ending number or 1..10000 by example.
  In C/AL use setrange.

  0
• kriki Member, Moderator Posts: 9,121

  2006-09-26

  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!
  
  

  0
• bindumlh Member Posts: 3

  2006-09-26

  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

  0
• kriki Member, Moderator Posts: 9,121

  2006-09-26

  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!
  
  

  0