FoxInCloud
Digital formatting
Gravatar is a globally recognized avatar based on your email address. Digital formatting
  Vincent H.
  All
  Dec 16, 2021 @ 01:58am

Hi Thierry,

We have a bug that seems to be related to opening the same folder (or the same screen ?) in multiple tabs.

At the exit of the field, the numerical values are found truncated. Ex: 100 000 becomes 100

I send you by email a scenario allowing to reproduce ...

If I type 100000 instead of 100 000, the value is not altered when I return to the field

Thanks in advance

Gravatar is a globally recognized avatar based on your email address. re: Digital formatting
  FoxInCloud Support - Thierry N.
  Vincent H.
  Dec 16, 2021 @ 02:48am

Hi Vincent,

We confirm the behavior, thanks for raising the issue.

Actually this bug happens even in single tab or window scenario; it's due to the way val() behaves:

VAL() returns the numbers in the character expression from left to right until a non-numeric character is encountered

If users types a number with a thousands separator (eg. 400 000 or 400,000), the FoxinCloud server executes Val() which chokes on the first non-numeric character (resp. ' ' and ',' in these examples), resulting in 400

We've updated this code to removes all non-numeric character from the typed string:

(applicable to V 3.0.0-beta.6 +)

modify command abDev

replace

            lTrue(m.tlNlitt),;

              strtran(m.tuValue, '.', m.lcPoint),; && 2021-10-30 thn -- {FiC V 3.0.0-beta.5} {en} added for https://support.west-wind.com/Thread66D0H3XML.wwt

par

            lTrue(m.tlNlitt) and !Empty(cEuroANSI('s')),;

              Chrtran(strtran(m.tuValue, '.', m.lcPoint), Chrtran(m.european, '+-$0123456789'+m.lcPoint, ''), '') + cEuroANSI(.T.),; && 2021-10-30 thn -- {FiC V 3.0.0-beta.5} {en} added for https://support.west-wind.com/Thread66D0H3XML.wwt && 2021-12-16 thn -- {FiC V 3.0.0-beta.7} {en} changed for https://support.west-wind.com/Thread67T048NY1.wwt


Gravatar is a globally recognized avatar based on your email address. re: Digital formatting
  Vincent H.
  FoxInCloud Support - Thierry N.
  Dec 16, 2021 @ 04:40am

Thanks Thierry,

It works perfectly again

© 1996-2025