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.
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.
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.
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.
15 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
