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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
