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: <[email protected]> > > 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. > > > > > > Kevin > > > > > > --- Lloyd Milligan <[EMAIL PROTECTED]> wrote: > > > > > >> This has something to do with initials being an > > >> output transform. If you > > >> use INTERNAL(ENTERED BY), EQUALS, 73 it should work. > > >> > > >> Lloyd > > >> > > >> ----- Original Message ----- > > >> From: "Kevin Toppenberg" <[EMAIL PROTECTED]> > > >> To: <[email protected]> > > >> Sent: Sunday, March 20, 2005 7:59 AM > > >> Subject: Re: [Hardhats-members] Another example of > > >> Fileman Search being > > >> unreliable > > >> > > >> > > >> > Still doesn't work. > > >> > > > >> > I went back to that particular record, and > > >> reentered > > >> > value for ENTERED BY field. I entered 'kst', and > > >> it > > >> > expanded to 'TOPPENBERG, KEVIN S' (By the way, > > >> kst's > > >> > DUZ=73) > > >> > > > >> > I then looked at the data with VPE's VGL function. > > >> > Here it is. You can see that node;piece 13;2 > > >> (field > > >> > 1302=ENTERED BY) here = 73 (Also, I looked at the > > >> > global data for other documents that I had not > > >> > re-entered, and they also were 73.) > > >> > > > >> > ==================================[Session > > >> > 1]================================== > > >> > 1) ^TIU(8925,4299,0) = > > >> > 1305^34245^^^7^^3041105^3041105^^18 > > >> > 2) ^TIU(8925,4299,12) = > > >> > 3050207.210339^74^^74^11^^^^74^^11 > > >> > 3) ^TIU(8925,4299,13) = 3041105^73^U > > >> > 4) ^TIU(8925,4299,14) = ^^^3 > > >> > 5) ^TIU(8925,4299,15) = ^74 > > >> > 6) ^TIU(8925,4299,"TEXT",0) = ^^27^27^3050207^^ > > >> > 7) ^TIU(8925,4299,"TEXT",1,0) = > > >> > > > >> > I then re-ran the search. Still no matches. Here > > >> it > > >> > is: > > >> > > > >> > > > >> > OUTPUT FROM WHAT FILE: TIU DOCUMENT// > > >> > > > >> > -A- SEARCH FOR TIU DOCUMENT FIELD: authOR OF NOTE > > >> > AUTHOR/DICTATOR > > >> > -A- CONDITION: = EQUALS > > >> > -A- EQUALS NEW PERSON: ptt THWING,PHILIP T > > >> ptt > > >> > PHYSICIAN > > >> > > > >> > -B- SEARCH FOR TIU DOCUMENT FIELD: entereD BY > > >> > -B- CONDITION: = EQUALS > > >> > -B- EQUALS NEW PERSON: kst TOPPENBERG,KEVIN S > > >> > kst PHYSICIAN > > >> > > > >> > -C- SEARCH FOR TIU DOCUMENT FIELD: > > >> > > > >> > IF: A&B AUTHOR/DICTATOR EQUALS 74 > > >> (THWING,PHILIP T) > > >> > and ENTERED BY EQUALS 73 > > >> > (TOPPENBERG,KEVIN S) > > >> > OR: > > >> > > > >> > STORE RESULTS OF SEARCH IN TEMPLATE: [TMG SET > > >> > (Mar 20, [EMAIL PROTECTED]:09) > > >> > User #73 File #8925 SEARCH > > >> > > > >> > > > >> > DATA ALREADY STORED THERE....OK TO PURGE? NO// y > > >> YES > > >> > DESCRIPTION: > > >> > This can be used to store sets of records, for > > >> working > > >> > with multiple > > >> > records etc. > > >> > > > >> > Edit? NO// > > >> > > > >> > SORT BY: NUMBER// > > >> > START WITH NUMBER: FIRST// > > >> > FIRST PRINT FIELD: .01 DOCUMENT TYPE > > >> > THEN PRINT FIELD: > > >> > Heading (S/C): TIU DOCUMENT SEARCH// > > >> > DEVICE: TELNET > > >> > TIU DOCUMENT SEARCH MAR > > >> > 20,2005 07:34 PAGE 1 > > >> > DOCUMENT TYPE > > >> > > > >> > > > > > > -------------------------------------------------------------------------------- > > >> > > > >> > > > >> > > > >> > > > >> > 0 MATCHES FOUND. > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > Thanks > > >> > > > >> > Kevin > > >> > > > >> > > > >> > > > >> > --- Floyd Dennis <[EMAIL PROTECTED]> wrote: > > >> > > > >> >> The problem appears to be with your data, not > > >> with > > >> >> FileMan. > > >> >> > > >> >> Look at the ENTERED BY field in your record 4299. > > >> >> If it were reflecting a > > >> >> true pointer value, then your inquiry should > > >> reflect > > >> >> the full name > > >> >> "TOPPENBERG,KEVIN S" (like the full name "THWING, > > >> >> PHILIP T" is displayed for > > >> >> the AUTHOR/DICTATOR field). It does not; what is > > >> >> displayed appears to be > > >> >> the literal 3-letter initial/abbreviation "kst". > > >> >> > > >> >> A look at the entry on the global level should > > >> >> verify whether the field > > >> >> contains a numeric pointer value or a literal > > >> text > > >> >> value. Did you use a > > >> >> 4-slash field edit (field_number////value) to set > > >> >> the value for the field? > > >> >> Such a field edit can cause literal data to be > > >> >> "forced" into a field and > > >> >> override any input validation checks. > > >> >> > > >> >> > > >> >> > > >> >> > > >> > > > >> > > > ----------------------------------------------------------------- > > >> >> The mockingbird can change its tune eighty-seven > > >> >> times in > > >> >> seven minutes. Politicians regard this > > >> interesting > > >> >> fact > > >> >> with envy. > > >> >> > > >> >> Floyd Dennis > > >> >> [EMAIL PROTECTED] > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > > >> >> On 3/19/05 11:26 PM, "Kevin Toppenberg" > > >> >> <[EMAIL PROTECTED]> wrote: > > >> >> > > >> >> > Here is a screen log showing fileman search not > > >> >> > finding records that do exist... I'd like to > > >> give > > >> >> up > > >> >> > on it and write my own... > > >> >> > > > >> >> > Kevin > > >> >> > > > >> >> > > > >> >> > > > >> >> > OUTPUT FROM WHAT FILE: TIU DOCUMENT// > > >> >> > > > >> >> > -A- SEARCH FOR TIU DOCUMENT FIELD: author OF > > >> >> NOTE > > >> >> > AUTHOR/DICTATOR > > >> >> > -A- CONDITION: = EQUALS > > >> >> > -A- EQUALS NEW PERSON: ptt THWING,PHILIP T > > >> >> ptt > > >> >> > PHYSICIAN > > >> >> > > > >> >> > -B- SEARCH FOR TIU DOCUMENT FIELD: enterED BY > > >> >> > -B- CONDITION: = EQUALS > > >> >> > -B- EQUALS NEW PERSON: kst TOPPENBERG,KEVIN > > >> S > > >> >> > kst PHYSICIAN > > >> >> > > > >> >> > -C- SEARCH FOR TIU DOCUMENT FIELD: > > >> >> > > > >> >> > IF: A&B AUTHOR/DICTATOR EQUALS 74 > > >> >> (THWING,PHILIP T) > > >> >> > and ENTERED BY EQUALS 73 > > >> >> > (TOPPENBERG,KEVIN S) > > >> >> > OR: > > >> >> > > > >> >> > STORE RESULTS OF SEARCH IN TEMPLATE: [TMG SET > > >> >> > (Mar 20, > > >> [EMAIL PROTECTED]:07) > > >> > > > === message truncated === > > > > > > > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! Small Business - Try our new resources site! > > > http://smallbusiness.yahoo.com/resources/ > > > > > > > > > ------------------------------------------------------- > > > 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 > > > [email protected] > > > 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 > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > > A practical man is a man who practices the errors of his forefathers. > --Benjamin Disraeli > ==== > Greg Woodhouse > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > > > > ------------------------------------------------------- > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/hardhats-members > A practical man is a man who practices the errors of his forefathers. --Benjamin Disraeli ==== Greg Woodhouse [EMAIL PROTECTED] [EMAIL PROTECTED] ------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
