Hi Manish, Direct answer: 1. If you are using SQL, then Open Query Analyser(QA) perform the following query: select schemaid from control 2. Note the number ---- *important 3. update control set schemaid=369 go 4. Then import HelpDesk def file. 5. Once this is complete then go back do the following using QA: update control set schemaid=(please set the id that you noted earlier in Step # 2). go
For argument sake, if HelpDesk form is deleted then all the objectsdirectly related to that form gets deleted. Thanks & Regards, Phani. Voip: +44 20718 25413 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Saturday, May 26, 2007 7:42 PM To: [email protected] Subject: Re: How to restore Form on the same schema id. ** Manish, Your best bet would be restoration of the database. It is possible to mess with the meta data but if you are not familiar with stuff in there, I wouldn't even advise you to go there... The arschema is not the only place this ID is referenced. Its referenced in several other meta data schemas such is field, activlink related meta tables, filter related meta tables, etc.. Just not worth tweaking with it all if you do not know what you are doing.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint Inc., New Jersey. ----- Original Message ---- From: Manish SINGLA <[EMAIL PROTECTED]> To: [email protected] Sent: Saturday, May 26, 2007 9:04:50 AM Subject: How to restore Form on the same schema id. Hello List, Can you please advice me that how I can re-create a particular form which is deleted by mistake, with the same schema as it had earlier. Say for e.g. I have HPD:Helpdesk with schema id 369 and if I delete this form and I try to take the def of same form my development environment and import on this machine it allocates me schema id 911. Please advice me if there is some way by which I can create HPD:Helpdesk with same schema id 369. Thanks Regards Manish ________________________________ Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: <http://us.rd.yahoo.com/evt=48253/*http://mobile.yahoo.com/go?refer=1GNX IC> mail, news, photos & more. __20060125_______________________This posting was submitted with HTML in it___ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
