Display NAV field properties w/ SQL Server statement

Michael_GER

Hi,

I want to design a SQL Server report to display certain NAV table properties.

Example:

Table:__________Field:____________Data Type:____OptionString:
Sales Line_________Document Type______Option__________Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order
...

As far as I know it is saved as a BLOB reference in SQL Server.

Is there any way to convert it via TSQL to user-readable text for further display processing?

Thanks for any hint.


Regards,

Michael

kine

No, there is no way how to do it from SQL directly...

Michael_GER

Thanks.

Any other idea how to solve this problem and finally get it to SQL Server?

It has to be a dynamic routine, in case the object was updated or modified.

kine

No, but there is described solution to do it from NAV (using recordref, going through all options and reading the option string etc., it is easy because in NAV you have the Field virtual table you can use to save these info into some new table and than read it from SQL).

stryk

Maybe this could help you to retrieve the option string:
http://www.mibuso.com/dlinfo.asp?FileID=1101