Topic: Space in Itemnumber
I have a customer where during the import itemcodes with a space in it came in the DB.
I want to change that by taking the spaces out of the itemcodes in the following tables
item_codes -- fields item_code and stock_id
loc_stock -- fields stock_id
prices -- fields stock_id
sales_order_details -- fields stk_code
stock_master -- fields stock_id
stock_moves -- fields stock_id
The itemcode without the space is unique.
If I disable the foreign key, change all tables and enable the foreign key again will this do the job?