Update Syntax

oldforum

• July 16, 2007 00:00

• Answered

Follow

Hello David ,

Trying to figure out how to set up a update statement using Clover , I am reading a series of records from a file. I need to update the records based on the primary key of the table.

Can you please post some examples.

Thanks
Subbu

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Hello !
  
  It should work like this:
  <Node id="OUTPUT" type="DB_OUTPUT_TABLE" dbConnection="NorthwindDB" sqlQuery="update myemployee set FIRST_NAME= ?, LAST_NAME=? where ID=?" cloverFields="FirstName;LastName;EmplID"/>

Please sign in to leave a comment.