topic Re: Update cell data to Database Table in FlexSim Forum

Update cell data to Database Table

anutt_k — Sun, 02 Jul 2023 16:17:27 GMT

[ 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.

Re: Update cell data to Database Table

jason_lightfoot_adsk — Sun, 02 Jul 2023 19:00:26 GMT

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.

Re: Update cell data to Database Table

anutt_k — Mon, 03 Jul 2023 06:36:31 GMT

Can you give some exam script ?

Re: Update cell data to Database Table

moehlmann_fe — Mon, 03 Jul 2023 07:07:17 GMT

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.

Re: Update cell data to Database Table

julie_weller — Fri, 07 Jul 2023 13:59:23 GMT

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.