I'm working on an external .NET application to show some data from Navision tables by accessing the SQL Server. If the table has an OptionString field, I would get an integer instead of the string representation.
Does anyone know where this string information is stored in SQL Server?
Currently I'm using enum to map the optionstring in my .NET application, but everytime I change the OptionString in Navision, I have to update the application also.
I know I could have used Code field combined with FlowField for this purpose, but wasting a table just for storing 3 options is too expensive for me.
Any thoughts and help will be very appreciated.