Process Model

Hi All,

Please help me with the below query.

1) created the variables in the start node and updating the data to DB by uing write to data store entity and it successfully creating the lines items in DB

now, we want the update the values through process model which is already present in the DB.

thanks in advance.

  Discussion posts and replies are publicly visible

Parents
  • So, you know you can Write INSERT statements to DB.  That happens when you either don't provide an ID, or one like -1, or the ID you provide doesn't correspond with an existing row.  If the ID DOES map to an existing row, Appian automatically converts to an UPDATE statement.

    Whether it's INSERT or UPDATE is determined at runtime on a row-by-row basis.  You want this data in that row, you got it!

    This does present a challenge for how to force Appian to pick either only Insert or only Update.  If you need to UPDATE, you have to be absolutely certain you have the row ID.  If you want to make sure you do INSERTs, you have to be absolutely certain you do NOT have the row ID.

Reply
  • So, you know you can Write INSERT statements to DB.  That happens when you either don't provide an ID, or one like -1, or the ID you provide doesn't correspond with an existing row.  If the ID DOES map to an existing row, Appian automatically converts to an UPDATE statement.

    Whether it's INSERT or UPDATE is determined at runtime on a row-by-row basis.  You want this data in that row, you got it!

    This does present a challenge for how to force Appian to pick either only Insert or only Update.  If you need to UPDATE, you have to be absolutely certain you have the row ID.  If you want to make sure you do INSERTs, you have to be absolutely certain you do NOT have the row ID.

Children