sql view creating problem

Business Central/NAV Technical Forum
1

Hai

i created view in sql server 2000 through sql query but i can’t view as the same.

by

Mariyappan.J

2

Not sure what you really mean by this question. Are you saying you can’t add the view as a NAV linked table? Make sure you have granted read permissions to the view to the users that will need to use it. You also need to ensure that the field types match - you may need to cast some of your fields to ensure they meet the standard NAV field types.

3

how to create view and how to link with navision

by

Mariyappan.J