Hi,
I just ran across an interesting problem when doing the above conversion. In our old ActiveX we defined our fields as adVarWChar, now OLEDB does not accept adVarWChar, so I used advarchar. I am getting different results.
With adVarWchar if you move "Rev Trks" to a field define with length of 14 there are no trailing blanks, with advarchar if I move "Rev Trks" to the field I get "Rev Trk ". This is causing problems when we are checking for "Rev Trks". There are many instances where we check for these type of constants.
Can anyone tell me what I can use when creating a field for a DLL in OLEDB.
Thanks.
I just ran across an interesting problem when doing the above conversion. In our old ActiveX we defined our fields as adVarWChar, now OLEDB does not accept adVarWChar, so I used advarchar. I am getting different results.
With adVarWchar if you move "Rev Trks" to a field define with length of 14 there are no trailing blanks, with advarchar if I move "Rev Trks" to the field I get "Rev Trk ". This is causing problems when we are checking for "Rev Trks". There are many instances where we check for these type of constants.
Can anyone tell me what I can use when creating a field for a DLL in OLEDB.
Thanks.