Update cell data to Database Table

[anutt_k]

[ FlexSim 23.1.2 ]

Hello. I want to export data from FlexSim GlobalTable to Database Table (SQL Server).

Now I can use this script to INSERT data to Database Table.

But INSERT It will be add new row in Database Table everytime when execute the script.

Then, I has change from INSERT to UPDATE for update new data only. (I won't to add new row). So that invalid.

How can I just update new data to old row and won't to add new row in Database Table. Thank You.

[jason_lightfootVL7B4 · Accepted solution]

Either DELETE * FROM test2 and then perform inserts for the whole table, or update based on a unique field combination (key ) using the WHERE clause.

[anutt_k]

Can you give some exam script ?

[moehlmann_fe]

UPDATE Test2 SET C1 = :C1, C2 = :C2, C3 =  :C3 WHERE ID == :ID

Requires to bind the ID column value as a parameter as well to be able to find the matching row in the WHERE clause.

[julie_weller]

Hi @Anutt K, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.