Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community
Forums » Microsoft Dynamics NAV / Navision » NAV / Navision - Technical Forum » How to retrieve value of an option field vis N/ODBC coonection

How to retrieve value of an option field vis N/ODBC coonection

rated by 0 users
This post has 1 Reply | 2 Followers

Not Ranked
Male
Posts 8
Points 205
Member since 12-12-2005
Reply
suryaaryal Posted: 09-17-2008 10:21
Hi,Do anybody have an idea about retrieving value of an option field while accessing Navision Database using N/ODBC. When we query NAV database via ODBC connection, the option field returns integer values (its true that option field stores integer value in the database). If there is any method to get value of option field, please do reply. Thanks in advance.

 

Surya Aryal Agile Solutions Pvt. Ltd. Kathmandu, Nepal
Top 75 Contributor
Male
Posts 312
Points 4,475
Member since 11-06-2005
Reply
babrown replied on 09-17-2008 12:43

If you are using N/ODBC (and therefore the native database) then this is available as a setting in the N/ODBC configuration.  If you are on SQL (therefore not using N/ODBC but SQL ODBC driver) then this is not available.

  • | Post Points: 5
Page 1 of 1 (2 items) | RSS

Copyright Dynamics User Group, 1995-2009, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.