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)

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)