Retrive all records from a Table

Chetan

My Task is very simple,

1. Retrieve all the records from the Table(G/L Entry)
2. Use SetFilter on the required field which is not PrimaryKey
3. Check whether record/local variable it is empty or not.

I am struck with first point, I am unable to retrieve all the records.
GET will require Primary Key as the value

Please help me on how to retrieve all the records from G/L Entry table. Many Thanks for your help in advance.

mohana_cse06

Use SETRANGE
https://msdn.microsoft.com/en-us/library/dd355053.aspx

Chetan

Hi Mohana,

Thanks for your message. I am new to NAV.

I was under impression that we have to retrieve all the records once the new variable is created. Now I understood that it was not necessary.

matttrax

Look up the different FIND commands.

mohana_cse06

First you have to set filter on non primary key using SETRANGE or SETFILTER
then use IF recordvarible.ISEMPTY THEN to check whether recordvariable is empty or not.

Chetan

Got it guys, Thanks

Verndroid

If you just want all the records then all you need to do is declare the variable glentry and then do
glentry.findset();