Running a Query

Hi

 

I have created a query and when I run it, it will only display the first 1000 records. How do I amend this to show all records?

 

Thanks

 

James

  • HI James,

    The Preview will show you first 1000 Records only, but when you want to use it in Code you will get all records as result of query.

    You can read all records like -

    Qry.OPEN;
    WHILE Qry.READ DO BEGIN
    END;
    Qry.CLOSE;

    If you are using NAV 2016 Refer Use of Query in Codeunit 410 Update Analysis View, Function - UpdateEntriesForGLAccount.

    Regards,
    Saurav Dhyani
    saurav-nav.blogspot.com
  • Hey James,

    It will display you only 1000 records as Query has something called SkipToken which skips as soon as 1000 data get displayed.
Related