Hello i am trying to update a primary key field and i get the error that the fields do not exists. Can some one walk me through the steps.
I am using the Rename function since i want to update one of the other 4 primary key fields i have.
I am using the Rename function since i want to update one of the other 4 primary key fields i have.
What do you mean by "... since i want to update one of the other .."? You have to provide all primary key fields in their proper order as parameters to the RENAME function, regardless of which of these fields has changed or not.
I am able to compile fine with no errors. When i run the Process report it renames the first records and for the second one it error out. Sorry for not being clear what i meant was i have 4 fields as primary keys and i want to update only the first one.
Comments
I solved this by using a temporary table.
Thank you for your help.