Update data to upper case in parent/child tables

Posted on 16th Feb 2014 07:03 pm by admin

Hi Gurus!

In production we have a product table and which is being reference by many tables making it parent child relationship. By mistake, we realized that last month some product were added in lower case and now we got a request to update all these product codes to upper case so that the existing code that use these tables have no impact. Appreciate if you can give some idea on how can I update the existing data in the parent table to upper case along with the child records?

Regards

Your Answer:

Login to answer

Other forums

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

Problem Dereferencing
With these types and tables:

CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,

Need help with cin setw
I made a program here is my code:

#include
#include
#i

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

(sub)screen resize modification doesn't work after ECC 6 EhP 4 installation
Hello,

We have previously extended the size of the custom data tab on PO transaction ME23

Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The

How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEM
and remove the

does anyone know a php script to send mail using gmails/googles free smtp server
cause i heard u can do that but i dont know how

Problems generating word documents on server side for security reasons
I have a problem with word documentation generation when generating a word document (docx) with PHP.

Blocking video streaming
Hello everyone,

I post a message here because i didn't find any solution yet.
I just finis