problem with query that returns no value

Question

question

Enrique Elizaga asked Mar 22, '19 Joerg Vogel edited May 25, '20

problem with query that returns no value

Hi, Is there a way to avoid an error during execution for a sum query on a Global Table that returns no values (because the filter criterium is not in the table).

Example. I search for the value X67 in the column MODEL in a table, and sum the quantities manufactured in other columns. If the X67 is not a value, it returns an error.

Software Version:

FlexSim 18.2.3

query query error isnull

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2019-03-22T17:58:22Z

Joerg Vogel answered Mar 22, '19

I saw a SQL clause ISNULL that replaces the null reference by a value. It is in a description of the Statistical Collector Output per Hour. Maybe it will work for you, too.

Perhaps the clause IFNULL works already in FlexSim. Please try it on your own.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question