Return to FileMaker.com
Set Field By Name
i'm using the function "Set Fields By Name" cuz i'm trying to mimize my script by removing the IFs, the problem is that when i do
Set Field By Name ("Table::Field "&$nb ; "Table::Field "&$nb + $data)
The $nb is incremented via the script (to indicate which field), and $data is the data i want to insert and it's added to the info already existing in the field.
the blue part works fine, but the red one doesn't work properly cuz filemaker is taking it as a "text" concat to a number, so my fied contains the whole sentence "table::Field 1 2" (for example).
any help :)
Do it this way:
Set Field By Name ("Table::Field " & $nb ; GetField ( "Table::Field " & $nb ) + $data)
Retrieving data ...