Add/modify SQL table

Question

Trying to determine best way to code this requirement :

• Need to insert rows to a SQL table having a multiple key index (PlantID,Year,Month).
• Row may already exist could update or delete existing row.
• Row contains around 150 fields that is dirived form other SQL tables.

Trying to determine simplest way to accomplish , I have thought would like to use SQLDataAdaptor, any ideas would be appreciated.

Answer 1

The SQL Query is easy:

Delete any existing rows first.

DELETE FROM table WHERE PlantID = "..." AND Year = "..." AND Month = "..."

And now insert the new one:

INSERT 
     INTO table (PlantID, Year, Month, other_col_1, ..., other_col_n)
     VALUES("...", "...", "...", "...", ..., "...")