The SQL Server / Azure SQL DB connector seems to have intermittent problems with this.
Again today I cannot patch the following number without it's significant figures being cut.
-236,339,979.64
If patching a new record, i.e. Patch(Source, Defaults(MySource), {MyNumber: -236,339,979.64}) then to
-236,339,979.6
If editing a record, i.e. Patch(Source, MyRecord, {MyNumber: -236,339,979.64}) then to
-236,340,000
This is important otherwise we cannot do our accounting...
@AndyPennell may be interested in this
