AnsweredAssumed Answered

Find not finding what it's supposed to

Question asked by PeterThorton on May 20, 2012
Latest reply on May 21, 2012 by PeterThorton


Find not finding what it's supposed to



apologies for posting an oversized screenshot, I wanted all the pieces of the puzzle to be visible.

In short, I'm trying to make a script, whose functionality depends on the Find step finding the appropriate record.

In the screenshot you can see that my CustomPrice table contains a record with ProductID of 1 and BusinessPartnerID of 2. You can also see that the step right before the Find shows a custom dialog that displays the values of the two variables. The dialog box confirms that the value of $$ProductID is indeed 1 and $$BusinessPartnerID is set to 2. The screenshot does not show this, but I hope you'll take my word for it.

Yet the search performed in the next step finds nothing. How is this possible? What is it that I'm missing? What other factors could affect the result of the search?