1 Reply Latest reply on Oct 6, 2009 10:48 AM by TSGal

    Validation Error in Time Field

    jonesp

      Summary

      Validation Error in Time Field

      Description of the issue

      I believe I have encountered a bug with either Filemaker or the PHP interface. In our database is a simple table called "time" with a single field called "time_field", which is a time of day field. We are able to do whatever we want with this field when using the Filemaker client software, however when using PHP to change or add records, we have a significant restriction on the time we can enter, namely, the number of minutes in the time cannot be 0.Below is an exact copy of the page we used to test this: Time:  A variety of inputs have been tested, including 3:00, 3:00:00, 3 PM, 3:00 PM, and each time an error occurs, frustratingly with a blank error message ( getMessage() returns an empty string ).We are running PHP 5.2.4 and FileMaker 9.0.3.325 on OSX Tiger, and any light you can shed on this issue would be greatly appreciated.

        • 1. Re: Validation Error in Time Field
          TSGal

          jonesp:

           

          Thank you for your post.

           

          The problem was reported at the end of the FileMaker Pro 9 life cycle, and it was fixed in FileMaker Pro 10.  In essence, as you have discerned, the hour/minute/second range was not allowing a zero.

           

          TSGal

          FileMaker, Inc.