Thanks David, The attributes ATT2 etc, I used are defined as single-valued D types. I have also tried using the keyword 'SINGLEVALUED'. It (UV/SQL) just seems to be aware of the multivalue marks and won't clear them. For the moment I have gone with creating a new item and updating it with the attributes I want to keep from the old item. Stuart
>-----Original Message----- >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'; ********************************************************************** 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/