Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Tue, 24 Feb 2015 09:21:08 -0800 |
Content-Type: | multipart/alternative |
Parts/Attachments: |
|
|
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
-
Sara Patrello
Assistant Registrar
Smart Museum of Art
The University of Chicago
5550 S. Greenwood Avenue
Chicago, IL 60637
<mailto:[log in to unmask]> [log in to unmask]
773.702.9549
<http://smartmuseum.uchicago.edu/> smartmuseum.uchicago.edu
<http://smartmuseum.uchicago.edu/>
Celebrating 40 years in 2014-2015
To unsubscribe, send an email to [log in to unmask]
<mailto:[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.
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.
|
|
|