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

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

Page Reload
I am having issues getting a page to reload after I submit data to a database. This form should inp

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

Socket problem
Hello,

Earlier I posted about my problem with my socket script. It took up to 100% CPU usage.

Perplexing problem showing a .jpg
Please disregard..........I figured it out

I need desperate help with this php code integrated with flash please
Can someone please help me with this php code which I have been stuck on for weeks . I am trying to

a multi dimensional array with for each
hi, I have been asked to write an array, I have Zone 2,3,4,5,6,7,8 each zone has 3 sections of weigh

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...