Steve, >>> SEL COUNT(*) INTO vrows INDIC iv2 FROM master where .this_custnub2 + in (sel custnub2 from customer where parentcustid = '105') and hub le + 999999 <<< Are you getting the correct answer? I am not sure if you want to calculate a count from Master or customer. The sub select is normally used to limit the records that match the criteria of both tables; in this case, there does not appear to be a link between the master and customer tables. I believe that you have to explicit link the tables via a column.
Javier, Javier Valencia, PE 913-397-9605 Home 913-915-3137 Cell 913-649-2904 FAX -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Breen Sent: Saturday, December 12, 2009 4:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Speeding up 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. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
