Thanks Guys... I don't know what I was thinking... I somehow got the push fields in my head and ignored using the set fields.. it's working perfectly now... and I am thoroughly embarrassed... LOL.. thanks gents.. :-)
On Wed, Nov 9, 2011 at 6:37 PM, Brien Dieterle < [email protected]> wrote: > ** > Or, yeah just listen to Rune. You had it exactly right just using the > wrong action. I was doing the same thing but I was trying to use a static > value in the set fields operation instead of a variable pulled from the > matching (duplicate) record. Can't use a static value. Nevermind, I've > just made things needlessly complicated. > > Brien > > > On 11/9/2011 4:28 PM, Rune Kristian Sørlid wrote: > > ** > Hi. > > Try using a set field instead of a push field. > > /Rune Sorlid > > Den 9. nov. 2011 kl. 23:58 skrev Jase Brandon <[email protected]>: > > ** Hello All, > Windows 2008 > 7.6.04 SP1 > > I have a field named 'Prefix' on COM:COMPANY. I need to make sure that on > submit that the value for 'Prefix' does not already exist. > > I have two filters - > Filter #1 > Fires on submit, exec order 0, the Run IF = 'Prefix' != $NULL$ > One If Action - Push Field to COM:COMPANY (same form) IF = $Prefix$ = > 'Prefix' > Push field action = 'zTmpPrefix' = $Prefix$. (I added a char field > 'zTmpPrefix') > > I see this working perfectly in the logs as shown below. I see it find the > value "ALT" and do the push fields action without any problem. > > Filter #2 > Fires on Submit, exec order 999. > The Run IF = 'ZTmpPrefix' != $NULL$. > I also tried 'zTmpPrefix' = $Prefix$ to no avail. > > This fails and doesn't fire my error message. I know I am missing > something horribly simple, but I've spent two hours on this and wanted to > reach out to the gang. :-) > Please see log below. This is where I got frustrated with the filters and > tried with AL's - same result. I've tried using `! on the filters, every > trick I know. Any ideas? I'm admittedly tired and wanted to see if someone > could help a brother out. :-) > > Thanks, > Jase Brandon > > *<ACTL>* *Checking ++QTS:COM:COMPANY Customer Prefix is Unique (0)* > *<ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Push Fields > <ACTL> To Schema COM:Company on Server @ > > <ACTL> (536870917) = ALT* > > <ACTL> Checking +QTS:Com:Company Require Customer Type (0) > <ACTL> -> Failed qualification > <ACTL> Checking COM:CPY:Company_010_CompanyIndexChk (10) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Set Fields > > <ACTL> z1D Char01 (1000000058) = "" > <ACTL> Checking COM:CPY:Company_011_CompanyIndexChkMsg (11) > <ACTL> -> Failed qualification > *<ACTL> Checking ++QTS:COM:COMPANY Customer Prefix is Unique Error (999) > <ACTL> -> Failed qualification* > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
