SQL View - Not Working???!!!

r44712r44712 Member Posts: 40
edited 2008-01-22 in SQL General
Hi all,

I'm trying to use a SQL View to display a large quantity of information across several tables.

The View is written and returns the data as expected.

However, in Navision the table is "blank"

In Navision, the table's LinkedObject property is set to 'Yes' as is the LinkedTransaction (same database / server).

If I try and set the LinkedObject property to false, it complains about an existing object, and if I try and enter a field (that is not part of the view) it complains also. I'm deducing from that, that Navision "knows" it is there.

I do not believe it is a permissions issue, as I can run the view with both my 'regular' and 'super user' logins onm the SQL Server within the Management Studio. It makes no difference if I login to Navision with either of these.

Is there something that I've missed (had a look at the ADG - next to useless)? ](*,)

THanks for any advice!


  • krikikriki Member, Moderator Posts: 9,079
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • ara3nara3n Member Posts: 9,253
    Delete the object. Recreate the table. Make sure you change dataPer Company to No and change Link Property to Yes. At the time of saving the object Navision will make the association with the view.
    Ahmed Rashed Amini
    Independent Consultant/Developer

    blog: https://dynamicsuser.net/nav/b/ara3n
  • WaldoWaldo Member Posts: 3,412
    If the view is company-dependant, please make your name like "CompanyName$viewname". use the "viewname"-name as your table name.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.