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

CE 7.1 and External GIS integration
Hi All,

We want to develop an application on CE 7.1 which uses GIS features from an exter

login to other site by sending post variables
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

Socket problem
Hello,

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

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

#include
#include
#i

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

Strange Oracle Query problem
Ok So I have this PHP class that talks to a Javascript class that basically creates a table of infor

Need help-Error istream header declaration
Hi Everyone ,

I am having issue with istream declaration. I am new to C programming.
can a