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,