mibuso.com
Home› SQL General

Problem with linked table

zutzuzutzu Member Posts: 86
edited 2009-02-10 in SQL General
Dynamics NAV 5sp1.
I have one table in Dynamics NAV linked with a view in SQL server.
I have a form that shows information of that table.
But when i export to excel (from the buttom or "copy and paste") the registers that shows the form in Dynamics NAV, i don´t get all the registers in Excel.
Any solution?

Answers

  • ara3nara3n Member Posts: 9,256
    The solution I can think of is on open form store the records into temp record, then display the temporary values on the form.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSterDenSter Member Posts: 8,307
    How many records are on the form? That export to Excel from a list form only pushes 500 records out be default.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • garakgarak Member Posts: 3,263
    how many recs you wan't to copy?
    Do you make it right, it works too!
  • zutzuzutzu Member Posts: 86
    They are, more or less, 80 records.
  • zutzuzutzu Member Posts: 86
    Solved:
    Properties of the table:
    LinkedInTransaction = Yes.
  • ara3nara3n Member Posts: 9,256
    Make sure you test this with running a transaction and reading data from the table. There are some settings on sql server that needs to be setup if the view is across different servers.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • bbrownbbrown Member Posts: 3,268
    zutzu wrote:
    Solved:
    Properties of the table:
    LinkedInTransaction = Yes.

    Don't use LinkedInTransaction if the view references data in another database.
    There are no bugs - only undocumented features.
Sign In or Register to comment.