AnsweredAssumed Answered

Using calculation with a mysql database

Question asked by ThaliMüller on Oct 30, 2013


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,