We ran in to a problem where one of our user fields in the Part Master got filled with wrong data. We use this field to sort reports such as the custom Sales Order Acknowledgement and Invoices we've created.
Anyway, we've corrected the problem in the part master but now I'm faced with propagating the changed data to the existing order detail records.
My first thought was to use Access via an ODBC connection to execute an UPDATE query joining on Part between the Part and OrdDtl tables. However I've seen lots of warnings about using Access to write to the Progress back end and am wondering if there's a better/safer way.
I don't know a whole lot about Progress, so can someone tell me how to issue a native SQL command in Progress? Basically I just need to update ShortChar08 in the OrdDtl table with the ShorChar08 value in the Part table for all records in OrdDtl.
Any help is greatly appreciated,
Sean
Anyway, we've corrected the problem in the part master but now I'm faced with propagating the changed data to the existing order detail records.
My first thought was to use Access via an ODBC connection to execute an UPDATE query joining on Part between the Part and OrdDtl tables. However I've seen lots of warnings about using Access to write to the Progress back end and am wondering if there's a better/safer way.
I don't know a whole lot about Progress, so can someone tell me how to issue a native SQL command in Progress? Basically I just need to update ShortChar08 in the OrdDtl table with the ShorChar08 value in the Part table for all records in OrdDtl.
Any help is greatly appreciated,
Sean