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) > 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 00:09 PAGE 1 > DOCUMENT TYPE >
-------------------------------------------------------> -- > > > > > 0 MATCHES FOUND. > > Press RETURN to continue... > > > > > And here is one (of about 1000+ documents that it > should have found.) > > > NUMBER: 4299 DOCUMENT TYPE: > OFFICE VISIT > PATIENT: xxxxxxxxxx,xxxxx x STATUS: > COMPLETED > EPISODE BEGIN DATE/TIME: NOV 05, 2004 > EPISODE END DATE/TIME: NOV 05, 2004 LINE COUNT: 18 > ENTRY DATE/TIME: FEB 07, [EMAIL PROTECTED]:03:39 > AUTHOR/DICTATOR: THWING,PHILIP T EXPECTED > SIGNER: THWING,PHILIP T > HOSPITAL LOCATION: Main_Office ATTENDING > PHYSICIAN: THWING,PHILIP T > VISIT LOCATION: Main_Office REFERENCE > DATE: NOV 05, 2004 > ENTERED BY: kst CAPTURE > METHOD: upload > SERVICE: FAMILY PRACTICE SIGNED BY: > THWING,PHILIP T > REPORT TEXT: xxx > > > Kevin > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > > >
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click> 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. >
https://lists.sourceforge.net/lists/listinfo/hardhats-members> _______________________________________________ > Hardhats-members mailing list > [email protected] >
-------------------------------------------------------
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=clickSF 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.
https://lists.sourceforge.net/lists/listinfo/hardhats-members_______________________________________________ Hardhats-members mailing list [email protected]
__________________________________ 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
