NEW2.02.04 · Released 13 February 2015
NEWfinPOWER Connect
Released in
2.02.04
13 February 2015
  1. Opened13 Jan
  2. Closed13 Jan
  3. Released13 Feb
Article 12569 Job J014743

Business Layer enhancement; added option to finBL.Database.GetFieldString to remove trailing spaces

A new parameter has been added to finBL.Database.GetFieldString in the finPOWER Connect Business Layer to remove trailing spaces

finBL.Database.GetFieldString now supports an additional parameter "rightTrimValue", which, if True, removes trailing spaces.

This parameter is optional, and the default if not specified is False - to maintain backwards compatibility.

' Without Right Trim
VariableName = finBL.Database.GetFieldString(dt!FieldName)
VariableName = finBL.Database.GetFieldString(dt!FieldName, False)

' Right Trim
VariableName = RTrim(finBL.Database.GetFieldString(dt!FieldName))
VariableName = finBL.Database.GetFieldString(dt!FieldName, True)