Hi, when I debug my macro, NQUOTE is 8,4 and NQUO2 is 16,4, but the condition IF>nquote>nquo2 is true!!
Why? Can you help me?
Thanks
GETCLIPBOARD and IF
Moderators: Dorian (MJT support), JRL
Re: GETCLIPBOARD and IF
I was going to suggest that you need to set the Decimal_Separator system variable to use a comma (,) but there appears to be a problem with the Decimal_Separator variable. The following does not evaluate properly.
Code: Select all
Let>decimal_Separator=,
Let>Bigger=16,4
Let>Smaller=8,4
Let>Product=%Smaller%*%Bigger%
Re: GETCLIPBOARD and IF
But my variables are OK:
THOUSAND_SEPARATOR=.
DECIMAL_SEPARATOR=,
THOUSAND_SEPARATOR=.
DECIMAL_SEPARATOR=,
Re: GETCLIPBOARD and IF
That is good. I did not know that because those variable assignments don't show in the image you posted.But my variables are OK:
What I am saying is that it appears that setting the Decimal_Separator variable to comma is not allowing scripts using comma as the decimal separator to work properly. I posted a short piece of code to demonstrate that.
If you run the code I posted you will see that the variable "product" is set to "8,4*16,4" rather than the product of the multiplication which should be 137,76.
So in your script where NQUOTE is 8,4 and NQUO2 is 16,4 the if statement thinks that "NQUOTE" is larger than "NQUO2" because "8" is larger than "1" . The comma is not being seen as the decimal separator even though you have set the "Decimal_Separator" variable to comma. Its supposed to work but something is broken.