Yes, it's 255. Dwayne
---- Original message ---- >Date: Thu, 16 Oct 2008 11:26:07 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: Creating subfile records from list on submit >To: arslist@ARSLIST.ORG > >Just off hand ... Is your Temp ID field at least 38 characters big? > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Thursday, October 16, 2008 11:21 AM >To: arslist@ARSLIST.ORG >Subject: Re: Creating subfile records from list on submit > >Thank you, Joe and Frederick ! > >I am trying the "Application-Generate-GUID" method. >My Filter does a "Set Fields" that sets a "Temp ID" field to: >$PROCESS$ Application-Generate-GUID > >I get, "**** Error while performing filter action: Error 38" > >I couldn't find anything about Error 38 in the BMC Knowledge Base. > >I tried putting quotes around "Application-Generate-GUID" even tho I >knew that was wrong, but got the same error. > >Any idea what I am doing wrong? > >Dwayne > >---- Original message ---- >>Date: Wed, 15 Oct 2008 14:22:45 -0700 >>From: Joe DeSouza <[EMAIL PROTECTED]> >>Subject: Re: Creating subfile records from list on submit >>To: arslist@ARSLIST.ORG >> >> ** >> You could also have the system generate a GUID on >> the parent record and store it in a hidden field >> that you could use to bind the child records to the >> parent record by pushing the GUID instead of the >> EntryID.. Create the GUID on opening the parent >> record if the GUID field is null, and use this. >> >> Use Application-Generate-GUID in a Set Fields Run >> process to generate it. >> >> Joe >> ----- Original Message ---- >> From: "Grooms, Frederick W" >> <[EMAIL PROTECTED]> >> To: arslist@ARSLIST.ORG >> Sent: Wednesday, October 15, 2008 4:49:33 PM >> Subject: Re: Creating subfile records from list on >> submit >> >> We put a Display Only "Processing ID" field on the >> 3rd form and have the main form push to the 3rd form >> (Standard Phase 2 action). All workflow on the 3rd >> form takes into account if Processing ID is Null or >> not. i.e. Data validation takes place if Processing >> ID = $NULL$. If Processing ID != $NULL$ then it >> pushes data to the subform (again standard Phase 2 >> action). >> >> Just to keep things clear we rename Modified Date >> and Last Modified By to Touched Date and Touched By >> and have our own Modified Date and Last Modified By >> fields that are filled in by a filter when >> Processing ID = $NULL$. >> >> Fred >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne >> Martin >> Sent: Wednesday, October 15, 2008 3:44 PM >> To: arslist@ARSLIST.ORG >> Subject: Creating subfile records from list on >> submit >> >> Dear List, >> >> I have a main form and a subfile form. The subfile >> has two (actually more, but this is just for >> illustration) fields, a Parent ID field that >> contains the Entry ID of the main form, and an Info >> field. On submission of the main form, I use a >> filter to retrieve a list from a third form, then >> process that list to create subfile entries. Eg, it >> would retrieve a list like: >> >> abcde >> hijkl >> mnopq >> >> Then if the main form Request ID is 87 it should >> produce subfile entries >> of: >> >> Parent ID: 87 >> Info: abdde >> >> Parent ID: 87 >> Info: hijkl >> >> Parent ID: 87 >> Info: mnopq. >> >> So, on submission of the main form, filters process >> the list, and move each entry on the list into a >> temp field and do a Push Field to create the subfile >> record. >> >> Here's the problem. Push Fields get deferred to >> phase 2, and by that time the temp field is >> overwritten so no subfile records get created. If I >> add `! to the end if the filter name, the filter >> runs in phase 1, but the main form Entry ID hasn't >> been created yet. >> >> The ideal would be to run the workflow in an Active >> Link "After Submit," but there are times when the >> main form itself is created via Push Field action, >> so the Active Links won't run. >> >> Any suggestions? >> >> (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) >> >> Dwayne Martin >> James Madison University >> __Platinum Sponsor: www.rmsportal.com ARSlist: >> "Where the Answers Are" html___ > >________________________________________________________________________ >_______ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"