Re: Problems deleting fields on a form - not deleted on the relat ed view

[McKenzie, James J C-E LCMC HQISEC/L3]

Title: Mensaje

**

Brian and Pilar:

 

It is possible that the field id was not dropped from the database. 

 

Here is what I had to do:

 

1.  Drop the field and make sure it was gone from all views (if you have one or two this is not a big problem, eight or nine, it can be.)

2.  Access Oracle through sqlplus as your ARS user.

3.  Find the associated table id for the form you want to drop the field from.

4.  Issue alter table T<tableid> drop C<fieldid>;

5.  If the field is an extended field (text more than 4000 characters, diary and attachment) there could be an associated B<tableid>C<fieldid> table AND a LargeObject table and index.

 

In practical experience, I found that text fields caused the most problems and needed this the most.

 

There is a solution to this problem, however, and that is to correctly size your database as a very large database.  Once we did this, no more missing fields.

 

James McKenzie

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luke, Brian
Sent: Tuesday, September 05, 2006 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Problems deleting fields on a form - not deleted on the related view

**

I assume you're speaking of  database views?

If so, drop the view in oracle, then save some form/field changes in the admin tool.  ARS should reconstruct the view.  (Please try this in dev first!)

 

-Brian Luke

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pilar Llorente Beltran
Sent: Thursday, August 31, 2006 7:00 AM
To: arslist@ARSLIST.ORG
Subject: Problems deleting fields on a form - not deleted on the related view

**

Hello,

 

We are working with ARS 6.3 and Oracle 9i in a HP-UNIX 11i server. Today we have moved 4 fields from a form but they haven´t moved from the view so we can't create them with the samed name/id. Any ideas?.

 

Thanks in advance. Regards.

 

Pilar.

---

Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningún sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electrónico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepción. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilización del correo electrónico via Internet y la grabación de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinión expresada en este mensaje pertenece únicamente al autor remitente, y no representa necesariamente la opinión de JAZZTEL, a no ser que expresamente se diga y el remitente esté autorizado para hacerlo.

*********

This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, please notify us immediately.Any views or opinions contained in this message are solely those of the author, and do not necessarily represent those of JAZZTEL, unless otherwise specifically stated and the sender is authorised to do so.

---

__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___