I'm working with SQL server as the database for Microsoft Dynamics Nav.
The constant problem i'm trying to work around is converting the Integer values from "Document Type" to the associated string.
"Interaction Log Entry" Table has a field called "Document Type"
These values are from 0 ="" to 25="Sales Invoice"
I'm using RecordSets (Microsoft ActiveX Data Objects 2.8 Library) to get the info from the SQL database.
how can i bring in the String instead of writing 8 difference functions to convert the associated integers to the values (one for each table i'm using)
SELECT [Entry No_],
[Contact Company No_],
[Time Of Interaction],
[Interaction Template Code],
FROM [Quick Corporate$Interaction Log Entry]
WHERE [Interaction Group Code] = 'SALES'
AND [Entry No_] > '10000'"