SQL NOT operator does not work

Question

question

Davidlan T asked Aug 28, '21 Davidlan T commented Oct 18, '21

SQL NOT operator does not work

Hi,

the following SQL-query doesn't work for me (ignore the odd variable names):

   
                  
                   Table dummy = Table.query("SELECT SUM(Average*Count) FROM Input_data WHERE Variable = $1 AND Hello_world NOT IN ('Iphone', 'I like cats')", parameter_1);

However, when I remove the NOT operator, the query works fine. I believe the syntax is correct according to FlexSim documentation, so what's going on??

And FYI, I do not use any special characters for my original variable names, only what you'll find in the english alphabet.

Software Version:

FlexSim 21.2.1

flexsim 21.2.1 iphone

Answer 1 · 2021-08-31T19:18:19Z

Jeanette F answered Aug 31, '21 Davidlan T commented Oct 18, '21

Hello @Davidlan T,

Your question states that you are using FlexSim version 21.2 which is the latest version of the software. The NOT operator is supported for versions 20.2 and later. Can you verify the version you are using?

Release Notes and History (flexsim.com)

· 1

Davidlan T commented · Oct 16, 2021 at 03:20 PM

Hi @Jeanette F

Thank you

0 ·

question