Where are stored the parameters of the fields in SQL

Fred_BL

Hi,

I have a request system which do request directly in the SQL Server database (Navision 4.01).
Where I select an option field I have a integer which represent the option index. I would like to have the option text but I can't find where it's stored in the database. Maybe there is a system table with all parameters of the fields but I can't find it.


Does somebody know ?

Thanks in advance for your reply.

DenSter

Those are not stored in a table that you can get to. The option values are part of the table definition, which is a blob field in the object table. You'll have to hard code the transformation from numbers to their text values.

ara3n

I suggest that you create a new table. Create a processing report in NAV to populate it with all the options, and you can use that table in your queries on sql.

garak

you can use this : viewtopic.php?f=33&t=30770 in use with a separete table where you stare also the options as text