Article Details
Id:10839
Product:finPOWER Connect
Type:NEW
Version:1.06.06
Opened:11/01/2013
Closed:11/01/2013
Released:29/01/2013
Job: J010974
High Importance

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