I think the 'only way', if this is a Universe file, not a UV/SQL table is to have a dictionary item for the same fields, that is not multivalued. I'm guessing you have some other code that is checking for 'empty string' in these fields? May try use "F1", "F2", etc.?
>UPDATE FILE SET NON-MV-ATT2 = '', NON-MV-ATT3 = '' WHERE @ID = 'FRED'; -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Boydell, Stuart Sent: Friday, 12 December 2008 2:37 PM To: [email protected] Subject: [U2] UV/SQL syntax 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 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
