DBohner-(db)
Legendary Poster
Howdy,
Looking for a means to validate Media Object Attachments in XE. Over the years, the Media Object Location has changed several times... for example: \\FileServer1, \\FS01 ... \\NAS01.... During those transitions - the XE.F00165.BLOB containing the attachments was not updated. The actual attachment may have been moved to the latest location - but there is no Row in the F00165 that will actually point to it.
So - two things...
- Can anyone think of a means to do a Mass Validation through the F00165 that will validate if the expected Media Object Exists?
- Can anyone think of a means to do an Update to the F00165.BLOB, providing the current location of expected Media Object (if it is found in new location)?
I know - painful. That's why I'm reaching out to see if someone has a suggestion I hadn't considered... yet.
(db)
Looking for a means to validate Media Object Attachments in XE. Over the years, the Media Object Location has changed several times... for example: \\FileServer1, \\FS01 ... \\NAS01.... During those transitions - the XE.F00165.BLOB containing the attachments was not updated. The actual attachment may have been moved to the latest location - but there is no Row in the F00165 that will actually point to it.
So - two things...
- Can anyone think of a means to do a Mass Validation through the F00165 that will validate if the expected Media Object Exists?
- Can anyone think of a means to do an Update to the F00165.BLOB, providing the current location of expected Media Object (if it is found in new location)?
I know - painful. That's why I'm reaching out to see if someone has a suggestion I hadn't considered... yet.
(db)