Re: Merges Vs. Submit and Modify for Filters

[Kemes, Lisa]

Title: RE: Merges Vs. Submit and Modify for Filters

**

When there is a change on Form A, the filter pushes the fields to a NEW record.

 

So your saying that, on a merge, the push is done first before there is even anything committed to the database.  So, really, when the filter is doing its push, it's pushing "NULL" values.

 

How would I get the import to commit to the database BEFORE the push is done?   Or maybe I'm asking the wrong question.  How can I get the filter to not PUSH until the data is committed?

 

Lisa

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Wednesday, October 11, 2006 12:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Merges Vs. Submit and Modify for Filters

**

Lisa:
 
Is the record a new record or an existing record?  The reason I ask this is the commit to the database will be done AFTER your push of data for a new record.

James McKenzie
L-3 GSI
 
________________________________

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Wednesday, October 11, 2006 9:27 AM
To: arslist@ARSLIST.ORG
Subject: Merges Vs. Submit and Modify for Filters

**

I have a "History" form that gets updated whenever Form A is changed.
The filter is activated on Merge, Submit and Modify and pushes the fields to the History form.
When I do a Submit or Modify on the form, the fields that are changed are pushed to the History form without any problems.

When I do an import ("Merge" action on the Filter), I get the error message "Required field cannot be reset to a NULL value -- Equipment List History : Serial Number (ARERR 326)"

I'm pushing the Serial Number field to the History Form for every change and it is a required field on the History Form. 

When I disable the filter, the import runs fine.  (yes, the serial number field is NOT Null on Form A)

Why is the import trying to reset this field to NULL?

Thanks in advance!

Lisa

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