Hi Antonio, To avoid any database intervention export all records in a ARX file - ID of every record and fiel you want to move. Assuming you do not have any filters executing on merge, import the saved ARX file using "update record" for duplicate ID.
Map the ID from ARX file to actual record ID and saved field to the new field. It will take no more than an hour. My advice is to do it in non working hour Daniel -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, October 09, 2006 7:07 PM To: [email protected] Subject: Re: Move Date/Time Field value to a date field using SQL Please specify what version of Remedy you are using and on what OS and db. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Antonio Acosta Sent: Monday, October 09, 2006 10:56 AM To: [email protected] Subject: Move Date/Time Field value to a date field using SQL Hello Lister, I`m in the process to move the values stored in a date/time field to a new one in the date field format. In the form exist at leats 1.000.000 records and I prefer to perform this updade via sql in order to not activate the filters defined over the form if I use an escalation. Is there any way to accomplish that? Any hints will be really appreciate. Thanks in advanced Antonio Acosta Consultant Caracas - Venezuela ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- *****DISCLAIMER***** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *****END OF DISCLAIMER***** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
