ISKeyValueList object's 'Set' methods now allow a UserDefinedIndex to be specified

The following methods of the ISKeyValueList business layer object can now optionally accept a 'userDefinedIndex' property.

The following methods have been updated:

• SetBoolean
• SetCurrency
• SetDate
• SetDateRange
• SetDecimal
• SetDouble
• SetInteger
• SetKeyValueList
• SetNumberRange
• SetString
• SetValue

The UserDefinedIndex property of a Key/Value List item is used when certain objects, e.g., finAccount are saved. Any User Data items for the Account that have a UserDefinedIndex between 0 and 9 will be stored in the 50 character User0 to User9 text fields on the database.

Although the ISKeyValueListItem object allows a UserDefinedIndex between -1 and 99, only values of -1 to 9 are currently supported for the finPOWER Connect database.

NOTE: It is not advisable to store non-String values in the database User0 to User 9 fields.

The following code sample will update a Client and set the 'VedaFileId' field and also that it is saved on the User3 field of the Client table:

' Load Client
Client = finBL.CreateClient()
Main = Client.Load("PAUL")
  
' Set User Data
If Main Then
  With Client.UserData
    .SetString("VedaFileId", "12345678", , 3)
  End With
End If

' Save Client
If Main Then
  Main = Client.Save()
End If