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

There was a problem with the request. (Code: 0)
Any Idea what could cause this? I get it randomly at best. But with both IE and FF. It derives from

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

Table control is disappearing from Screen
Hi Experts,

I have a screen with multiple table control(TC). Each table control has two c

MYSQL INSERT ID NOT WORKING
Code: $id = mysql_insert_id();
header("Location: ./?view=$id");
Why $id pulling blan

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files.

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re

How can I get my program to read a larger array ??
Hi:

I have this program that reads from an array to do calculations. The array are just t

making web pages for accounts
Hello, I would like to make pages for accounts on my website im making (its not a real website..im j