Please advise me if there is anyway of speeding this up. There is a 15-30 second delay Note: All Columns are indexed. Note: I am using this as a entry eep. -- Warranty.ent -- Set variable vwarranty -- Used to remind a user to Check A Spread Sheet for Customer Equipment Verification -- Major Assumption - var This_CustNub2 is set on form entry
Clear var vWarranty SEL COUNT(*) INTO vrows INDIC iv2 FROM master where .this_custnub2 + in (sel custnub2 from customer where parentcustid = '105') and hub le 999999 -- IF vrows > 0 THEN SET VAR vwarranty = 'Check warranty coverage for the unit before handling Breakdown' ELSE SET VAR vwarranty = 'TEST' ENDIF RECALC VARIABLES RETURN Stephen Breen CDI Services, Inc.
