Mysql IF - strange behavear

Post Reply
p_hd
Posts: 121
Joined: 03 Feb 2021, 11:40
Name: Pedro Viana
Location: Portugal - Braga
Company Name: Clever Solutions, Lda.
Contact:
Contact p_hd

Mysql IF - strange behavear

Post by p_hd »

Hi

I made a simple MySQL Formula if:

if( [3074]<=[3075] , "OK" , "NOK" )

But I'm getting this result
Captura de ecrã 2021-05-19 073333.jpg
In first row is correct, the second also correct, the third not correct it should be "NOK"

Rukovoditel version 2.8.3

Thanks.
Top
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Mysql IF - strange behavear

Post by support »

try
([3074]+0)<=([3075]+0)
Top
p_hd
Posts: 121
Joined: 03 Feb 2021, 11:40
Name: Pedro Viana
Location: Portugal - Braga
Company Name: Clever Solutions, Lda.
Contact:
Contact p_hd

Re: Mysql IF - strange behavear

Post by p_hd »

support wrote: ↑25 May 2021, 15:48 try
([3074]+0)<=([3075]+0)
Thanks Sergey

It works.
Top
Post Reply

Return to “Bug Report version 2.8”