ralvy

Text function RIGHT on FM Server 14 v4 reports incorrect value

Discussion created by ralvy on Dec 15, 2015
Latest reply on Dec 15, 2015 by ralvy

I have a small database hosted at FMPHost.com and notice the following oddity when using the Right function on a text string:

 

Right ( "0001" ; 3 ) in FMPA 14 v4 Client (Mac) correctly returns "001". But FMS 14 v4 Server (Windows) returns "01".

 

Right ( "0001" ; 4 ) in FMPA 14 v4 Client (Mac) correctly returns "0001". But FMS 14 v4 Server (Windows) returns "001".

 

FMPHost says they're running FMS 14 v4 on Windows Server 2008 R2 machines.

Outcomes