Start a new topic

API virtual field annoyance - Help!

Hi All,

I have been going in circles as I can't figure this code out. I have written the below to enable me to prefix an inbound value. I have tested it in the Test Code bit of my profile and it appears to be working. However when I try to run it on a real import the field remains blank and nothing is imported. 

Anyone have got any suggestions on what is going wrong?


 <ImportOM.API.VirtualColumn("AIM_Comments")> _

 Public Function ComputedColumn_636542859968720326( _

    ByVal oField as ImportOM.API.iField, _

    ByVal Cancel As ImportOM.API.iCancel) As String

 Dim sReturn As String = ""

  If oField IsNot Nothing

   If oField.Value.Trim <> "" Then

    sReturn = ("AIM_" + oField.Value)

  End If

    end if

   Return sReturn

 End Function

Login or Signup to post a comment