Ron,

It helps!

I added the ghost Attachment fields back from Current View - Fields in
View, and then deleted all Attachment fields before I deleted the newly
added dummy Attachment pool. All attachment fields are now gone.

Thank you very much!

Happy New Year!


Kevin

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Gehring
Sent: Thursday, December 30, 2004 10:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: A deleted attachment field still there for Open Window

Kevin,

As we learned, if you just delete the attachment pool, it does not
automatically delete the attachment fields themselves. Check the Find
Field menu with the form open in the admin tool to see if the attachment
fields are still associated with the form. If they are, add them back
using the Fields In View menu (you will have to create a new attachment
pool), delete the individual attachment fields in the pool field
properties then delete the pool.

Hope this helps...

Ron Gehring

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Lai
Sent: Thursday, December 30, 2004 12:02 PM
To: arslist@ARSLIST.ORG
Subject: A deleted attachment field still there for Open Window

Dear Listers,

I noticed an interesting and anoying behavior, which makes my Direct SQL
DB insertion Filter action impossible.

The form "myForm" I want to "Open Window" used to have an attachment
pool with attachment field 1 to 10. They are long deleted. But when I
have "Open Window" action perform on this Form, "Fields in Dialog Form"
still prints long gone fields Attachment 1 to Attachment 10.

This doesn't appear to be the case for a regular field. I created a
dummy character field, saved the form, "Open Window" "Fields in Dialog
Form" did list the dummy field. I deleted the dummy field, "Open Window"
"Fields in Dialog Form" didn't list the dummy field anymore.

But for the Attachment Pool attachment field, they remain there after
the deletion.

This causes me a problem when I want to do "Direct SQL" to insert
records into the form: "ARERR[552] Failure during SQL operation to the
database:
Update or insert of view or function 'myForm' failed
because it contains a derived or constant field" (SQL Server 4406)

Does anyone have a solution for this problem?

Any help is very much appreciated! Thank you!

Happy New Year!


Kevin




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)