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?

Did you know?Explore Trending and Topic pages for more stories like this.
Regards
No comments posted yet

Your Answer:

Login to answer
170 Like 44 Dislike
Previous forums Next forums
Other forums

Help with Password Encoding/Decoding?
Trying to design a "change password" tool. On my signup code I'm using base64_encode, now

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

Transport data between itab and textfield on ALV event
Hallo,

I have a ALV Grid ( cl_gui_alv_grid ) and I also have hotspot click event with a h

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

New Login Script
Hi all, i attempted to create a whole new login script witch isnt working for some reason i dont kno

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash