Article Details
Id:12569
Product:finPOWER Connect
Type:NEW
Version:2.02.04
Opened:13/01/2015
Closed:13/01/2015
Released:13/02/2015
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)