1 2 Previous Next 18 Replies Latest reply on Jul 15, 2015 7:57 AM by philmodjunk

    System Format "English" is not overriding "Portuguese" Win 7 created File

    IJ

      Summary

      System Format "English" is not overriding "Portuguese" Win 7 created File

      Product

      FileMaker Pro

      Version

      Advanced 13.0v5 hosted at a cloud service server

      Operating system version

      Problem happens saving at both OS X 10.10.4

      Description of the issue

      This database was created in a Portuguese formatted Windows 7 computer to be used in the US (ONLY!). The file is set to keep the System Format, and a script loads when the file opens enforcing the system to :

      If [Get (SystemLanguage) = "English"]

      Set Use System Formats [On]

      End If

      Notwithstanding, decimal numbers using system settings Data Formatting display correctly when the file is opened in Filemaker, but not when opened in Webdirect, when "." (period) decimal divider is substituted by "," (coma) instead. Meaning that one entering data in Webdirect with ". " (period) gets an unexpected different number: e.g., entering in Webdirect 3.85 gets 385 instead!

      The problem is that this Advanced Pro database was working well in both ways (in Filemaker and Webdirect) and in a sudden started with this problem. Since the database is hosted by a cloud service, I suspect that a latest server update may be causing this problem. Heads up, I ("Compacted") saved the file several times in a US IOS computer changing all possible alternatives I had to see if it would solve the Internet access problem with no success.

      Any clue on how to fix this bug?

      IJ

      Steps to reproduce the problem

      Enter number data in Webdirect (both in a US windows or US OS X formated computer) using "." (period) as decimal divider (e.g 3.5) displays no decimals on field exit, and displays decimals with "," decimal divider when the intertion point is in the field (e.g 385 on field exit and 3,85 when "clicking" the field)

      Expected result

      3.5 displayed at exit field and 3.5 when field is "clicked".

      Actual result

      385 on field exit and 3,85 when "clicking" the field

      However, when the same 3.5 number is entered into the field running Filemaker instead, Webdirect displays 3.5 in the field and 3,5 when the same Webdirect field is "clicked"

      Exact text of any error message(s) that appear

      N/A

      Configuration information

      Database is hosted by a cloud server service provider.

      The database was downloaded from the server to an OS X 10.10.4 Mac and "saved as" to "compact":
      1) Keeping the Use System Format option
      2) Not keeping the Use System Format option
      3) All field where checked to have English as Default Language
      4) Number fields Separators are System settings selected

      Workaround

      No.

      FILEMAKER_X_WEBDIRECT_AND_WEBDIRECT_X_WEBDIRECT.png

        1 2 Previous Next