Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Re: Removing Space by SQL

From: (2015-10-26 12:25)

Sounds to me like you have two values with a unique attribute that are almost the same on that column.
Removing the space will leave you with the same value twice, violating the constraint.
Ex. 'item123' and 'item123 '
You may need to remove one of the records from the system, or somehow rename the offending record to use a different primary key.
Jorge H. Collado
Information Systems Administrator
________________________________
Orange County Utilities
PLEASE NOTE: Florida has a very broad public records law (F. S. 119).
All e-mails to and from County Officials are kept as a public record.
Your e-mail communications, including your e-mail address may be
disclosed to the public and media at any time.