ARS 6.3 running on Solaris Oracle 10g I have 2 forms. Service Request (Parent) and Service Request Task (Child).
I have field "Delivery Address" - 255 char field. I have a filter that says whenever Delivery Address != DB.Delivery Address then run. The filter gets the db value and sets it to a temp field in first action - This works fine 2nd action updates a worklog with the temp field info. - This also works fine. 3rd action is my problem. I have tried it 2 ways. First way (partial failure) was to update all task forms that had the same Service Request ID with a push field. This works, but only for the last record it finds (as seen in the logs). None of the other children get updated. The push was set to "Modify All Matching Requests". When I looked at the logs, I also ran the sql log. It looks like the db is updating the 2nd record but fails to do so for the first. *SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000048' * *UPDATE T1907 SET C536870950 = EMPTY_CLOB() WHERE C1 = 'VTSK00000000048' * *SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000048' FOR UPDATE * *Set LOB into the above row... * *UPDATE T1907 SET C536870955='99 New York Avenue Washington, DC 20001',C536870956=1309752000,C5='vvisual',C6=1292442282 WHERE C1 = 'VTSK00000000049' * *SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000049' * *UPDATE T1907 SET C536870950 = EMPTY_CLOB() WHERE C1 = 'VTSK00000000049' * *SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000049' FOR UPDATE * *Set LOB into the above row... * *COMMIT WORK* 2nd way I tried was to do a filter guide that walks a table that lists all tasks. That didn't work AT ALL!!!! Anybody have any idea what might be going on? Warren R. Baltimore II Remedy Developer 410-533-5367 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
