Here is a SQL statement that will insert a FlexField.INSERT INTO UserFieldXrefs (UserFieldID, ID, ContextID, FieldValue, ValueRemarks, LoginID, UserFieldGroupID) SELECT [YOUR USER FIELD ID], Objects.ObjectID ,1, '[YOUR FIELD VALUE]', '[YOUR VALUE REMARKS]', '[YOUR LOGIN ID]' ,-1 FROM Objects WHERE ObjectNumber = 'YOUR OBJECT NUMBER'In order to create inserts for a large group of Flex Fields, the best approach is to put the data into an EXCEL spreadsheet and use a CONCATENATE statement to create the SQL lines. Attached is an example of how to do it. Click on cell F1 to have the CONCATENATE statement show up in the data entry box. Call if you need help.
Richard Grant
Executive Director
3214 College Avenue
Berkeley, CA 94705
[log in to unmask]
510.428.1400 ext 4
510.459.4556 mobile
Instagram | TwitterTo unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:Hello folks! Does anyone just happen to have a SQL statement for batch adding flex fields to a group of object records, say for example an object package?To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:Thanks!--Fatima Mahdi
Collections Information Specialist/TMSVirginia Museum of Fine Arts
200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
Fatima Mahdi
Collections Information Specialist/TMS
Virginia Museum of Fine Arts
200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.