Joined: 31 May 2006 Posts: 200 Location: Netherlands
Sorry I did not pay attension to your sentence 'Can we update the key field ADDR as mentioned below,'
As far as I know changing the value of any primary key would result in a new row. Primary key is the field is the basis for selection of rows, so how can you change the value for the same. If you change it would be trated as a new row but can not replace the old one.