Kevin: Could you post the standard data dictionary listing for the ENTERED BY field?
On 3/21/05 8:44 PM, "Kevin Toppenberg" <[EMAIL PROTECTED]> wrote: > So again, to simplify this for my benefit, we have: > > 1. input of "kst" --> IEN=73 > 2. IEN of 73 in File#200="TOPPENBERG,KEVIN" > 3. because "kst"<>"TOPPENBERG,KEVIN" match fails. > > This is especially frustrating because it expands > "kst" to TOPPENBERG,KEVIN But apparently is either > comparing 73 to TOPPENBERG,KEVIN or comparing "kst" to > TOPPENBERG,KEVIN. > > Needs a fix. > > Kevin > > --- steven mcphelan <[EMAIL PROTECTED]> wrote: > >> With equals, the lookup is done and resolved to a >> pointer in the Conditions >> prompt. When the search is actually performed, it >> compares the .01 field >> value of the pointed to file to the value of the >> field in the original file. >> Since that field has an output transform, the TIU >> field external value does >> not equal the external value of the pointed to file >> entry and thus no >> matches are found. However you select the lookup >> entry in the search >> condition portion is irrelevant. >> >> ----- Original Message ----- >> From: "Greg Woodhouse" <[EMAIL PROTECTED]> >> To: <hardhats-members@lists.sourceforge.net> >> Sent: Monday, March 21, 2005 12:49 AM >> Subject: Re: [Hardhats-members] Another example of >> Fileman Search being >> unreliable >> >> >>> I should apologize for being a bit behind the >> curve on this one. When I >>> initially suggested using "=" instead of "equals", >> it's because I was >>> wondering if it might result in a lookup by IEN >> without using INTERNAL. >>> I guess I should have just looked it up. >>> >>> >>> --- Greg Woodhouse <[EMAIL PROTECTED]> wrote: >>> >>>> I was wrong. When there is no index on the >> pointer field (even if >>>> there >>>> is an output transform) Fileman handles the >> lookup properly in the >>>> search dialog. That's not the problem. >>>> >>>> But if I an output transform of >>>> >>>> S Y="ABRA KADABRA" >>>> >>>> the search suddenly fails (though the lookup >> succeeds). >>>> >>>> --- Greg Woodhouse <[EMAIL PROTECTED]> wrote: >>>> >>>>> That was my understanding, but consider thhat >> the basic symptom is >>>>> that >>>>> we are comparing a pointer field for equality >> after doing a lookup >>>>> (selection after entering the '=' condition), >> but Fileman fails to >>>>> find >>>>> a value when entering one lookup value >> ("kst"), but it does succeed >>>>> when entering the .01 value. >>>>> >>>>> I'm not suggesting that the SEARCH uses and >> index, but that the >>>> user >>>>> dialog makes use of an index when looking up a >> pointer value for >>>>> comparision purposes. I'll have to try it out >> under another >>>> scenario >>>>> and see if this occurs consistently. >>>>> >>>>> --- Greg Kreis <[EMAIL PROTECTED]> >> wrote: >>>>> >>>>>> The A, B, C conditions don't use an index. >> They are 'if' >>>>> statements >>>>>> that are applied to records that are found >> by the SORT BY part of >>>>> the >>>>>> >>>>>> Search. Now, depending on how the SORT BY >> is constructed, it can >>>>> use >>>>>> an >>>>>> index or simply order through all the >> records of the file in >>>> record >>>>>> order. >>>>>> >>>>>> Kevin Toppenberg wrote: >>>>>> >>>>>>> Is the search dependant on an index? What >> if I were >>>>>>> to define a file that did not have an >> index. Would it >>>>>>> not be searchable? I thought it was >> sweeping through >>>>>>> all records in the given file. >>>>>>> >>>>>>> Regarding the DIC("PTRIX"), surely the end >> user is not >>>>>>> expected to do this...(?) >>>>>>> >>>>>>> Thanks >>>>>>> Kevin >>>>>>> >>>>>>> --- Greg Woodhouse <[EMAIL PROTECTED]> >> wrote: >>>>>>> >>>>>>> >>>>>>> >>>>>>>> My guess is that Fileman in looking in the >> "B" >>>>>>>> cross-reference for >>>>>>>> "kst" and not finding it. When doing a DIC >> lookup, I >>>>>>>> think you need to >>>>>>>> set DIC("PTRIX") (I'm going by memory) if >> you want >>>>>>>> to look up a >>>>>>>> "pointed to" value using a different >> index. >>>>>>>> >>>>>>>> --- Greg Woodhouse <[EMAIL PROTECTED]> >> wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> It would still be interesting to know if >> the >>>>>>>>> >>>>>>>>> >>>>>>>> search fails when >>>>>>>> >>>>>>>> >>>>>>>>> entereing "TOPPENBERG, KEVIN" instead of >> "kst". >>>>>>>>> >>>>>>>>> >>>>>>>>> --- Lloyd Milligan <[EMAIL PROTECTED]> >> wrote: >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>>> Something about the ENTERED BY field DD >> seems to >>>>>>>>>> >>>>>>>>>> >>>>>>>> prevent the search >>>>>>>> >>>>>>>> >>>>>>>>>> from >>>>>>>>>> working as expected. As you pointed >> out, >>>>>>>>>> >>>>>>>>>> >>>>>>>> initials are a valid >>>>>>>> >>>>>>>> >>>>>>>>> lookup >>>>>>>>> >>>>>>>>> >>>>>>>>>> value. >>>>>>>>>> So why doesn't this work? >>>>>>>>>> >>>>>>>>>> Lloyd >>>>>>>>>> >>>>>>>>>> ----- Original Message ----- >>>>>>>>>> From: "Kevin Toppenberg" >> <[EMAIL PROTECTED]> >>>>>>>>>> To: >> <hardhats-members@lists.sourceforge.net> >>>>>>>>>> Sent: Sunday, March 20, 2005 8:33 AM >>>>>>>>>> Subject: Re: [Hardhats-members] Another >> example >>>>>>>>>> >>>>>>>>>> >>>>>>>> of Fileman Search >>>>>>>> >>>>>>>> >>>>>>>>>> being >>>>>>>>>> unreliable >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> Ok, that does work. >>>>>>>>>>> >>>>>>>>>>> But as far as I am concerned, THIS IS A >> BUG! >>>>>>>>>>> >>>>>>>>>>> Any reasonable user (and seasoned >> Fileman >>>>>>>>>>> >>>>>>>>>>> >>>>>>>> users on >>>>>>>> >>>>>>>> >>>>>>>>>>> this board) can't figure this out. >> > === message truncated === > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members