Bonjour Glenn,
This
is my first posting to this list.
The
following will erase the credit line existing in those records and replace it
with you new Credit line.
When I
have to do things like this, I do the work at the SQL level.
ATTENTION : BEWARE : You can damage and loose data if you are not
familiar with SQL. Proceed with EXTREME
care...
A)
Create an object package with a name and put your 800 objects in
it.
B) at
an sql prompt, find the ObjectPackageID of your object package with the
following:
select * from dbo.ObjectPackages where Name like 'name that you
gave before'
The
first column is the ObjectPackageID. Note that number.
Then,
do the following:
update objects
set
CreditLine = 'YOUR CREDIT LINE TEXT'
where objectid in
(select
objectid from dbo.ObjPkgList where ObjectPackageID = "The objectpackageid that you find in the preceding
request")
/*
Replace "The objectpackageid that you find
in the preceding request" with the number without " "
*/
Hope
this help
Luc Bissonnette
Bibliothécaire des systèmes/Systems Librarians
Gestionnaire des systèmes des collections
Centre Canadien d'Architecture/Canadian Center for
Architecture
Montréal, Québec
H3H 2S6
Téléphone: 514-939-7001 #2616
Télécopieur: 514-939-7020
[log in to unmask]
Hi
Everyone,
Has anyone had success
with doing gang entries to data fields. I would;like to enter a credit line to
a group of 800 plus objects in a group.
Thanks, Glenn
Glenn
Fye
Photoarchivist
Albuquerque Museum