Decimal seperator "weird" functioning.
This has kept me busy for almost 4 hours straight now, without any progress.
The main problem:
When I enter a number, in a numeric field (non-filtered), everything goes allright.
Once I enter that same value using a script, FileMaker (11 Pro Advanced, on a local DB) does not recognise the decimal seperator (although in both cases it's a period).
I've already checked my script's output with a dialog, but until the field, everything seems ok.
Just placing a period as text behind the first character is not an option in this case, due to the fact that the number will be somewhere between 5 and 80 000.
Yes, I know I over-use the PHP registering, but that was due to some other bug earlier in the process.
Both scripts are ran with full access privileges
The scripts that places the text into the field:
(times script, 60s interval)
Set Variable [$t; Value:PHP_Register]
Set Variable [$r; Value:PHP_Execute ( "$from = 'EUR';
Set Field [onrelevant::EURUSD; $r] //Store it in a numeric global storage field