(This did not seem to go through the first time I sent it. I think maybe my list subscription was from the wrong account? Hopefully, it is fixed now.)
DELETE FROM FILE_ASSOCIATION where @ID="FRED"; If there is not an appropriate association, you can use each dictionary name to clear them one at a time. The key is that in SQL, the association (or un-associated MV field) is treated as a sub table. What you want is to remove records from the sub-table. On 12/11/2008 at 9:37 PM, "Boydell, Stuart" <[email protected]> wrote: I have an item with several related MV attributes which I want to set to null using SQL. 001 Some data I want to keep 002 a]b]c]d 003 desc a]desc b]desc c]desc d 004 Some more data I want to keep If I use "UPATE FILE SET ATT2 = '',ATT3 = '' WHERE @ID = 'FRED'" I get 001 Some data I want to keep 002 ]]] 003 ]]] 004 Some more data I want to keep When what I really want is: 001 Some data I want to keep 002 003 004 Some more data I want to keep Is there a way to do this? Many thanks, Stuart Boydell ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
