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
