title: need to update the DB table through macros
body: <p>I need to do the below update through macros,</p>
  
  <pre><code>If tbname = "PARTY" Then
  Dim ssql As String
  ssql = "Update PARTY Set PARTY_ID= (SELECT (max(PARTY_ID)+1) FROM PARTY) WHERE PARTY_ID ='DUMMY'
  DB.Execute ssql, 64
  End If
  </code></pre>
  
  <p>I am getting this error, while running the above statement.</p>
  
  <blockquote>
    <p>Error Code: 1093. You can't specify target table 'PARTY' for update in
    FROM clause   0.000 sec</p>
  </blockquote>
  
  <p>Is there any other way to update the <code>max(party_id)+1</code> to the row having party_id as "DUMMY"</p>