question

Enrique Elizaga avatar image
0 Likes"
Enrique Elizaga asked Joerg Vogel edited

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.

FlexSim 18.2.3
queryisnullquery error
5 |100000

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

1 Answer

·
Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered

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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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