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.
Implantation of Maximo a mass upload of our inventory was add to maximo. However, the binnnum location had spaces. I have to written SQL statement that works for the inventory default binnum, but trying to update invbalances
update invbalances set binnum = LTRIM(binnum) where siteid='XXXXX"
this statement works but it will not work on invbalance. It give me a error of
ERROR: A violation of the constraint imposed by a unique index or a unique constraint occurred.
Is there a work around?
thanks
Aside from the unique constraint issue, you might look at using a replace function to remove spaces regardless of where they are in the binnum field.
SQL Server: REPLACE Function http://www.techonthenet.com/sql_server/functions/replace.php
http://www.techonthenet.com/sql_server/functions/replace.php
SQL Server: REPLACE Function http://www.techonthenet.com/sql_server/functions/replace.php This SQL Server tutorial explains how to use the REPLACE function in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact...
View on www.techonthenet.com http://www.techonthenet.com/sql_server/functions/replace.php
Preview by Yahoo