Renewed question - SQL query to delete EV archive or change ArchivingState (MbxArchivingState = 1 to 4)?
Before I'm going to wreck anything i'd like to get some clarification on the following (closed) forum dicussion:
There is mentioning of different field "names" in the solution (thanks Jesuswept) and the replies:
- ArchivingState --> Assume this is same as "MBXArchivingState"
- MbxArchivingState (change from 1 to 4)
- Archivestatus (in one of the replies)
I created an SQL query that only displays the fields and their relationships, but there is BOTH an MBXArchivingState AND ArchiveStatus.
Can you tell me which of the fields will be changed from 1 to 4 in this statement or is it both?