5 Replies Latest reply on Jan 30, 2017 9:05 AM by philmodjunk

    SQL view in FileMaker

    mihirhumnabadkar

      HI,

       

      I have an SQL table view in FileMaker. The field in SQL is of the datatype Real and in FileMaker when we synchronize the fields, the field has datatype as Number in FileMaker. When i enter a value like 0,99 in FileMaker view, it shows 0,99000001 but in SQL it shows 0,99. Why is it so and is there any solution to show the vaue as 0,99 in FileMaker also?

       

      Please help!!

       

      Best Regards,

      Mihir Humnabadkar