question

Manu N avatar image
2 Likes"
Manu N asked anthony.johnson answered

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

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?

FlexSim 19.1.2
sqlsql queriessql queryversion control
· 1
5 |100000

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

Braydn T avatar image Braydn T commented ·

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

0 Likes 0 ·

1 Answer

anthony.johnson avatar image
2 Likes"
anthony.johnson answered

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.

5 |100000

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