Need some feedback from all your database SQL experts out there. We have been having an ongoing discussion regarding the use of Indexed fields within a Set Field If Action and/or a Push fields If Action qualification.
Here is what we are looking at. You have a form with three indexes, Inx1, Inx2, and Inx3. Either the Set Field If Action or Push fields If Action qualification is set up in this format. Form Field 1 = Database Field 1 AND Form Field 2 = Database Field Inx3 AND Form Field 3 = Database Field Inx1 AND Form Field 4 = Database Field Inx2 The question is does AR Server evaluate the qualification as whole and determine if any of the fields are indexed first and then pull a subset of records to find the last value "Form Field 1 = Database Field 1" or does it build the records sets in the order the Set Field If Action or Push fields If Action qualification is designed. Meaning it first pulls those records in the "Form Field 1 = Database Field 1", then Form Field 2 = Database Field Inx3, and so forth. Christopher Pruitt Business Consulting III HP Enterprises Services [email protected] www.hp.com<http://www.hp.com/> Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<attachment: Picture (Device Independent Bitmap) 1.jpg>>
