Question about Linked View and Option field

fabrizioc

Hi to all, in these days I've created a view in a SQL Server Databases to populate a Navision Table, I've created Navision table and configured as a Linked Object, all works fine but now I'd like to improve the behavior in the following way.....I have a column in the SQL View of type NVARCHAR(30) that contains an enumerable field, now I've translated the enumerable in the view code but I'd like to perform this action in Navision table.

To explain possible values in my enum are 0,1,2,3,4,5,6 so instead of translating the field in SQL layer I'd like to create an option field in Navision that translate enum values with correct descriptions.

Trying to do that I got an error because the Option type field doesn't match with the SQL View field (NVARCHAR(30))

Can someone suggest me a way to perform this action?

Thank you in advance for your advice.

Best regards
Fabrizio

Belias

use int instead of nvarchar