AnsweredAssumed Answered

FM adds a carriage return to the end of a lookup field

Question asked by texas0478 on Aug 11, 2018
Latest reply on Aug 24, 2018 by texas0478

Isssue description:


I am looking up a text field (DefaultOrderType) in the Orders table from the Suppliers table, based on a number (SupplierID). 


In the Suppliers table the DefaultOrder type is "n" characters long (e.g. 6 chars, "IN-OUT")

In the Orders table the looked-up DefaultOrderType will be n+1 characters long (e.g. 7 chars, "IN-OUT¶") – thus a carriage return [ char(13) ] is added during the lookup.


I believe this is some unexpected behaviour.