Update cell data to Database Table

Question

question

Anutt K asked Jul 2, '23 Julie Weller commented Jul 7, '23

Update cell data to Database Table

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.

Software Version:

FlexSim 23.1.2

database database export update database

1688314242482.png (101.7 KiB)

1688314365451.png (6.0 KiB)

1688314394040.png (50.1 KiB)

1688314405987.png (15.5 KiB)

· 1

Julie Weller commented · Jul 07, 2023 at 01:59 PM

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.

0 ·

Answer 1 · 2023-07-02T19:00:26Z

Jason Lightfoot answered Jul 2, '23 Jason Lightfoot edited Jul 3, '23

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.

· 2

Anutt K commented · Jul 03, 2023 at 06:36 AM

Can you give some exam script ?

0 ·

Felix Möhlmann Anutt K commented · Jul 03, 2023 at 07:07 AM

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.

1 ·

question