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