Hi folks, I am working with a legacy custom application on my ARS 7.0.1 system (Oracle 10 back-end) where the initial developer created a Price field as a decimal field. My problem is that now we are integrating this form with the CMDB (ITSM 7.0.03) and I need to get that data into a currency field. My initial thought was to create a new currency field named Cost and do a simple SQL update statement to get the data copied rather than rely on an escalation.
I thought that this statement would work and it does update the destination fields to the expected values, however when I look at the record in the WUT the new field is empty. Any idea why this might be or how to get around it via SQL? I will use an escalation if I have to but I don't like having to change the Modified Date on historical records. If there's a way to preserve the Modified Date with some smoke & mirrors I would appreciate that as well. My understanding is that there is come CMDB "black box" functionality that handles currency fields and I can import currency data into AST forms via a CSV file and that process works fine so apparently the import tool runs the data through that black box on the way into the AST forms. -Rick _________________________ Rick Westbrock Remedy Administrator | IT Department 24 Hour Fitness USA, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
