Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Is there an "Option-Field-Translation-Table"?
pupricht
Member Posts: 9
Me again...
...still migrating our old interface routines (ODBC) from Navision 4.x (native database) to NAV 2009 (MSSQL).
All off the old interfaces are using the ODBC drive with the option "OptionFieldType" set to "text"
(The "Identifiers" optin is set to "a-z,A-Z,0-9,_" which explains the "additional" underlines in the following sample statements)
Therefore selecting records in the old environment from lets say the "Cust_ Ledger Entry" table may look like this:
It's the option string < ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund> defining the mapping
Payment=1,
Invoice=2
....and so on...
The new MSSQL-Environment does not allow to choose between OptionFieldType Interger/Text.
Therefore I have to rewrite the above statement as
So far so good. Having access to the designer it's easy to find out what the integer value is.
I am wondering (remember I don't have the NAV 2009 application but only a connection via SQLNCLI) if there exists any table to "translate" option field integers into strings and/or vice versa?????
Something that would enable me to grab
Thank you
Peter
...still migrating our old interface routines (ODBC) from Navision 4.x (native database) to NAV 2009 (MSSQL).
All off the old interfaces are using the ODBC drive with the option "OptionFieldType" set to "text"
(The "Identifiers" optin is set to "a-z,A-Z,0-9,_" which explains the "additional" underlines in the following sample statements)
Therefore selecting records in the old environment from lets say the "Cust_ Ledger Entry" table may look like this:
SELECT fields FROM Cust__Ledger_Entry WHERE Document_Type = 'Invoice'
It's the option string < ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund> defining the mapping
Payment=1,
Invoice=2
....and so on...
The new MSSQL-Environment does not allow to choose between OptionFieldType Interger/Text.
Therefore I have to rewrite the above statement as
select * from [dbo].[Cust_ Ledger Entry] where [Document Type] = 2
So far so good. Having access to the designer it's easy to find out what the integer value is.
I am wondering (remember I don't have the NAV 2009 application but only a connection via SQLNCLI) if there exists any table to "translate" option field integers into strings and/or vice versa?????
Something that would enable me to grab
select IntegerValue, TextValue from [TranslationTable] where [FieldReference] = 'Document Type'
Thank you
Peter
0
Comments