GETCLIPBOARD and IF

Hints, tips and tricks for newbies

Moderators: JRL, Dorian (MJT support)

GETCLIPBOARD and IF

Postby lunalucky » Thu Dec 28, 2017 9:04 am

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
Attachments
Img.png
Img.png (70.87 KiB) Viewed 140 times
lunalucky
Newbie
 
Posts: 14
Joined: Thu May 18, 2017 2:13 pm

Re: GETCLIPBOARD and IF

Postby JRL » Thu Dec 28, 2017 2:23 pm

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%
User avatar
JRL
Automation Wizard
 
Posts: 3210
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Re: GETCLIPBOARD and IF

Postby lunalucky » Thu Dec 28, 2017 5:20 pm

But my variables are OK:
THOUSAND_SEPARATOR=.
DECIMAL_SEPARATOR=,
lunalucky
Newbie
 
Posts: 14
Joined: Thu May 18, 2017 2:13 pm

Re: GETCLIPBOARD and IF

Postby JRL » Thu Dec 28, 2017 5:36 pm

But my variables are OK:


That is good. I did not know that because those variable assignments don't show in the image you posted.

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.
User avatar
JRL
Automation Wizard
 
Posts: 3210
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa


Return to Beginners

Who is online

Users browsing this forum: No registered users and 3 guests