I need to do the below update through macros,
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
I am getting this error, while running the above statement.
Error Code: 1093. You can't specify target table 'PARTY' for update in FROM clause 0.000 sec
Is there any other way to update the max(party_id)+1
to the row having party_id as "DUMMY"