This was used in 9.35, but I expect it will still work.
UPDATE Objects
SET CreditLine = 'Your New Credit Line'
WHERE ObjectID IN (select ObjectID FROM ObjPkgList OPL
INNER JOIN ObjectPackages OP ON OPL.ObjectPackageID = OP.ObjectPackageID
WHERE OP.Name = 'Object Package Name')
Dick
Richard Grant
Executive Director
The Richard Diebenkorn Foundation
3214 College Avenue
Berkeley, CA 94705
510-428-1400
510-459-4556 (mobile)
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Sara Patrello
Sent: Tuesday, February 24, 2015 8:46 AM
To: [log in to unmask]
Subject: Batch Updating Credit Lines
Hello All,
Has anyone successfully batch-updated object credit lines in TMS on records that were previously made? If so, could you let me know what your process was?
Thank you!
Sara
— |
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.