Also, if you have any workflow that builds a qualification for use in an EXTERNAL() operator, you'll need to update that workflow (the string operations that build the qualification).
Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Shellman, David" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 02/16/2007 08:54 AM Please respond to [email protected] To [email protected] cc Subject Re: Changing field database names ** Susan, Yes you can change the database fieldname and it doesn't cause any issues with the data. However, if there are any reports that are pulling data from the tables at the database level using SQL, they will be effected. Not sure about Crystal Reports. This maybe depend on if accessing through the Remedy ODBC driver or directly at the database. Unless folks have edited the macros, you will find macros use the field number for reference. I believe that reports use the field label. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Friday, February 16, 2007 11:45 AM To: [email protected] Subject: Changing field database names ** Hi everyone, Yes, this is a simplistic question but I don't have my dev server to test it on right now because it's been upgraded. I generally don't do this but I have been requested to change about 20 fields. It's all right to have the field label and the field database name out of sync on a couple of fields but that many is too many to try and remember. It complicates imports and reporting. The questions are: Can I change the database field name without causing an issue with the data? I'm not deleting or replacing or changing the ID. Does a crystal report automatically pick up the field change? Would it affect any macros that people may have created? I appreciate any help you can provide, Susan Server: ARS 5.1.2 Patch 1428 OS: Windows NT 5.0 2CPU's 4G Memory Database: Oracle 9i2 User: ARS 5.1.2 Patch 1316 User OS: XP, NT, Win 2000 Admin: ARS 5.1.2 Patch 1289 Crystal that created reports: 9 Susan Palmer ShopperTrak 200 W Monroe St 11th Floor Chicago, IL 60606 Office: 312-529-5325 Cell: 302-502-7687 [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
