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.

Outcomes