Perry, Using the AE editor, you could create a pre-stored command that will execute in a loop.
This assumes that you will append a specific string constant or same numeric value to the same field, in every record. If you need help loading a prestore, then executing in a loop, feel free to tap me off line (unless others want to read or contribute to this thread). Thank you. -Baker -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Perry Taylor Sent: Tuesday, September 13, 2011 8:27 AM To: U2 Users List 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/> This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
