Home > IT Answers > How do I replace a field value?
Jmconyer
30 pts.
 How do I replace a field value?
How do I replace field values from other values in the same field?
I have a filed value that need to be replaced with a value from the same field based on another value in the table. Let's call the field "cost" in the table 'Location". The unique field is "item". In this case , an item exists in multiple locations, field name 'loc'. In each location, a unique item may have a different cost in each location. I need to replace the cost value in tertiary locations from the cost value in the primary location. I have no problem writing a script to replace all values in any given field, but I'm having trouble crafting a script for this process.

Software/Hardware used:
ASKED: June 12, 2009  5:06 PM
UPDATED: June 15, 2009  3:32 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi there,

Could you please specify what program you’re using?

Thanks,
Jenny
Community Manager

JennyMack
 4,265 pts.
 

The application is Macola ES. The database lives on a server running SQL 2000.

Jmconyer
 30 pts.