Is using UPDATE...SET statements on SQL queries advisable?

[manu_n]

[ FlexSim 19.1.2 ]

I recently found out from a colleague that query("UPDATE <Table> SET <column(s)> = <value(s)> WHERE <condition(s)>") statements work very well in FlexSim. However, since this query syntax is old and this functionality is not mentioned anywhere in the user manual, is it advisable to use it in models intended for long term use at the user end? Is there clarity on whether these commands will work in future versions as well?

[braydn_t]

As far as I know SQL isn't going anywhere.

[anthony_johnsonT83CM · Accepted solution]

The UPDATE clause is, and will continue to be, fully supported in FlexSim. You should feel fine using this clause and should not worry about losing support for it in future versions of FlexSim. Its exclusion from the manual is an oversight. We'll get it into the manual.