0 Replies Latest reply on Oct 30, 2013 8:35 AM by ThaliMüller

    Using calculation with a mysql database



      Using calculation with a mysql database



           I have the following problem. I use filemaker 12 with a mysql-database, which is connected by ODBC. 

           My sql-table "people" has the following fields: Pmin, Pmax, People

           The two fields "Pmin" and "Pmax" both contain some numbers. Those I would like to combine in the field "People" as text giving "Pmin to Pmax". I tried the following calculation:

           People = Pmin & " to " & Pmax

           In a pure filemaker field this works perfect, but the field in the mysql-Table just stays empty.

           So my question what did I do wrong?

           Thanks for your help in advance,