Enable DB Logging and see what the server is sending the database...
On Aug 2, 4:39 pm, Lyle Taylor <tayl...@ldschurch.org> wrote:
> Hi All,
>
> I have a table field that pulls in the Product Categorization Tier 1-3 fields
> from PCT:Product Catalog and am seeing weird behavior based on the
> qualification. I have search qualification fields on the form to help the
> user narrow down the list of tiers being shown in the table. My
> Qualification for the table has elements that look something like this:
>
> 'Product Categorization Tier 1' LIKE (("%" + $Tier 1 Search$) + "%")
>
> I just add AND clauses to that for the other two tiers. What I'm seeing,
> though, is that I get different behavior for each of the fields. For
> example, with just that above, and the Tier 1 Search field empty, I get all
> records displayed in the table. However, if I change the field referenced on
> the PCT:Product Catalog table to Product Categorization Tier 2 and still with
> the Search field empty, I get back 145 rows. If I change it to Tier 3, I get
> back 457 rows. In all cases, that should effectively be translating to the
> following:
>
> 'Product Categorization Tier X' LIKE "%%"
>
> But it's not behaving that way. Using that statement above, I get all rows,
> but as soon as I add the field reference to the Search field, I get less
> results for Tier 2 and Tier 3, even though the Search field is empty.
>
> Has anybody ever seen behavior similar to that? Any ideas how to fix it?
>
> AR Server 7.1
> ITSM Suite 7.0.03
>
> Thanks,
> Lyle Taylor
>
> NOTICE: This email message is for the sole use of the intended recipient(s)
> and may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy all
> copies of the original message.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
