Filtering records

bindumlh · 2006-09-26

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

mihai.valcea · 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.

kriki · 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);

bindumlh · 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

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

Filtering records

Comments

Categories