6 Replies Latest reply on Jan 17, 2017 7:42 AM by neonsword2003

    Commit Records/Requests

    neonsword2003

      Product and version FileMaker Pro Advance 14.0.3 & Filemaker Pro Advance 15.0.2

      OS and version Windows Pro 10

      Hardware Desktop ( 8 Core AMD FX, 8ram 2TB HDD )

       

      Description

       

      We found issue in the Commit Records/Requests with our database solution, We use Filemaker as a Front End and our Backend is MySQL with ODBC driver.

       

      Story,

       

      We have a table with mandatory fields. Our process is to create new record and the user must input data to the mandatory fields, and the layout is set to manual saving record. When the user tries to save the record and validate the mandatory fields, it generates an error when the mandatory fields are empty. Commit Records/Requests generate error number 509, field requires a valid value which is normal. The issue here is, instead of halting or stopping, it continues or force commit to create a new record. If the user saves it 5 times with validation field failed, it will create 5 blank records which is not normal.