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

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

downloading a file as HTML
Hi.
I'm rather confused with forcing a download. I just want to save dynamic content (from $_SESS

Code clarification
Hi

In the following code what could be the "search_print()" and where it could be

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

pagination numbering pattern
Hello,

I have following code which works great for pagination. but i have small issue now.

Help with email validation please...
Hi,
Please could you help.
I have a register.php login page where users register, the detail

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

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur