Dennis - thanks very much. It appears that somebody removed the unique index for sites on our form and as a consequence, you cannot use the Data Wizard to change the name of an existing site if a duplicate name exists.
Thanks for your help! Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: [email protected] W: www.computacenter.com From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Dennis Ruble Sent: 05 March 2009 16:05 To: [email protected] Subject: Re: OOB Indexes on CTM:Site ** Gavin, We're on ITSP 4.0. We have two indexes on CTM:Site, which I believe are OOB: 1. Unique index on 'Site' 1. Non-unique index on 'Country', 'State Province', and 'City' Regards, Dennis Ruble Rockwell Collins "Coleman, Gavin" <[email protected]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 03/05/2009 04:45 AM Please respond to [email protected] To [email protected] cc Subject OOB Indexes on CTM:Site ** Good morning list - can anyone who uses ITSP tell me what the OOB indexes on this form are? I have come across a problem with the CFG:Data Wizard and need to confirm what these indexes are. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: [email protected] W: www.computacenter.com ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
