I am updating a VB app to support multiple languages and have figured out how to read and display the data on the screen correctly.
We update the data using an excel import. The problem I am having is how to change the result set. See code fragment below:
The above if statement needs to be done whenever the column is mapped to type adVarWChar in the database (which is an nVarChar column in the Oracle DB).
There are other if statements to do conversions on other types (like dates) that also set the value in rsField. Those are working correctly.
I am trying to figure out what to do with ?????. adVarWChar seems to require a long for the Oracle DB... but I have managed to tie my brains in knots :)
Anyone with an idea?
We update the data using an excel import. The problem I am having is how to change the result set. See code fragment below:
Code:
Dim fileVal as Variant
' fileVal contains a byte variant with the correct unicode values read from the excel spreadsheet
if (m_dbColumns(p_colIdx).rsField.type = adVarWChar) Then
m_dbColumns(p_colIdx).rsField.Value = ??????
End if
There are other if statements to do conversions on other types (like dates) that also set the value in rsField. Those are working correctly.
I am trying to figure out what to do with ?????. adVarWChar seems to require a long for the Oracle DB... but I have managed to tie my brains in knots :)
Anyone with an idea?