Perry,
You need to do this by using the Dynamic Normalisation and INSERT.
INSERT INTO FILE_MVFIELD (@ID, MVFIELD) VALUES ('KEY', 'THE.NEW.VALUE')
More details can be found in the SQL User Guide Chapter 5.
HTH,
Andy
________________________________
From: Perry Taylor <[email protected]>
To: U2 Users List <[email protected]>
Sent: Tuesday, 13 September 2011, 14:26
Subject: Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE
Hrm... no bites??
Perry
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Perry Taylor
Sent: Thursday, September 08, 2011 10:11 AM
To: U2 Users List
Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE
I have a need to add an additional value to a multi-valued field on a bunch of
records. I was hoping I could do this using SQL UPDATE but it appears you have
to explicitly list all the muli-values...
UPDATE FILE SET MVFIELD = <'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE'>;
Anyone know of way to append a new value using UPDATE?
Thanks.
Perry
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.com<http://www.zirmed.com/>
CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is
prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health
Information, any communications containing such material will
be returned to the originating party with such advisement
noted. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the
original message.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
