Create a table from a view & retrieve data

Anthony04 · 2012-10-22

Hello everybody,

I ask you if someone know why my table can't retrieve data from my view ?

I show what I've got :
- My SQL view and my Navision table are in the same SQL Server database.
- My SQL view asked a database on another server, it works (only for the user "A")
So, in order to anyone can read data I have to create a table in Navision which retrieves the view result.

I understood that I have to create a table with the same name and the same column names and modify properties of my table :
- My View :

- My table in Navision :

-My table's properties :

When I try to run the table I have this message :

Help please

stryk · 2012-10-22

Hi!

Well, first of all you have to assure that the names of all fields and the table/view itself are identical - seems to be the case.

The datatypes must be compatibel - looks OK.

Further, NAV requires a unique PK also for such linked objects, thus you view must ensure the "invoicenumber" is unique, maybe using the DISTINCT operator in the view?! Are your values unique?

Then you also need to set the appropriate rights on your view, e.g.

GRANT SELECT ON [Sales-Invoices-PID] TO PUBLIC

Should work ... !?

kriki · 2012-10-22

And if Joerg's trick doesn't work, just a wild guess:
Don't use the '-' in the name but use blanks or don't use anything to separate the words of the tablename like "SalesInvoicesPID".
Another wild guess: maybe the collation is not correct.

Anthony04 · 2012-10-23

It doesn't work but thanks for your advices.

I'm trying something else and I'll tell you

Create a table from a view & retrieve data

Comments

Categories

Create a table from a view &amp; retrieve data

Comments

Categories

Create a table from a view & retrieve data