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

Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...

Code: $define_li

Taylor Series Function
So I am working a a project for my intro C++ class, and I am having some trouble with a function for

Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

How to load mysql (and other) extensions into PHP
How to load mysql (and other) extensions into PHP PHP Development forum discussing coding practices,

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

Problem with creating FI documents
Hi, Experts!

when i create Fi doc. with standart transaction, i ve been had such problem

query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:

Code: [Select]$query

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat