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