Validation Error in Time Field
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 220.127.116.115 on OSX Tiger, and any light you can shed on this issue would be greatly appreciated.
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.