A query containing a space character in an alias the result is No Data

Question

question

Joerg Vogel asked Jan 9, '18 Jordan Johnson answered Feb 2, '18

A query containing a space character in an alias the result is No Data

If I run a model containing a space character in an alias of a Table.query, I get a Flexscript exception. If I delete the space character, on the next run shows the cloned table only cells containing No Data. I have to save the file without the error, close Flexsim completely and open the model again to get results with valid data.

To reproduce this behavior, please open the model and run it. The query clause contains already the error. You get the exception error at the time stamp 300. Then erase the error by deleting the space character and let run the model again. The Table "Result2" contains cells stating No Data by the red corners.

I bring this to the front again, because the Problem still exists in Flexsim 18.0.2. I have attached an enhanced model, which has got a description, what to do to get a result in the Table "Result2" with valid data. query-table-with-alias-space-character-faulty.fsm.

Software Version:

FlexSim 18.0.2

Software Version:

FlexSim 17.2.5

bug no data query alias alias with space characters

faulty-alias-in-query.jpg (136.4 KiB)

cloned-query-table-no-data.jpg (33.6 KiB)

query-table-with-alias-space-character-faulty.fsm (21.0 KiB)

Answer 1 · 2018-02-02T19:43:34Z

Jordan Johnson answered Feb 2, '18

SQL syntax does not support spaces in the alias name, unless you put the name in brackets. So you can put the name in brackets:

SELECT $2 AS Obj, $3 AS Class, $4 AS Age, $5 AS [Type de] FROM $1

The bug is that once you try to run that bad query, some internal state of ours gets messed up. We should fix that. To get around this, fix the query, then close and reopen FlexSim. The new query runs fine.

question