Oh..... you are talking about the dialog to set up the search...
sorry. Greg Woodhouse 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 thesearch fails whenentereing "TOPPENBERG, KEVIN" instead of "kst". --- Lloyd Milligan <[EMAIL PROTECTED]> wrote:Something about the ENTERED BY field DD seems toprevent the search>fromworking as expected. As you pointed out,initials are a validlookupvalue. 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 exampleof Fileman Searchbeing unreliableOk, that does work. But as far as I am concerned, THIS IS A BUG! Any reasonable user (and seasoned Filemanusers onthis board) can't figure this out. Kevin --- Lloyd Milligan <[EMAIL PROTECTED]>wrote:This has something to do with initials beinganoutput transform. If you use INTERNAL(ENTERED BY), EQUALS, 73 itshould work.Lloyd ----- Original Message ----- From: "Kevin Toppenberg" <[EMAIL PROTECTED]> To: <hardhats-members@lists.sourceforge.net> Sent: Sunday, March 20, 2005 7:59 AM Subject: Re: [Hardhats-members] Anotherexample ofFileman Search being unreliableStill doesn't work. I went back to that particular record, andreenteredvalue for ENTERED BY field. I entered'kst', anditexpanded to 'TOPPENBERG, KEVIN S' (By theway,kst'sDUZ=73) I then looked at the data with VPE's VGLfunction.Here it is. You can see that node;piece13;2(field1302=ENTERED BY) here = 73 (Also, I lookedat theglobal data for other documents that I hadnotre-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 nomatches. Hereitis: OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: authOROF NOTEAUTHOR/DICTATOR -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: ptt THWING,PHILIPTpttPHYSICIAN -B- SEARCH FOR TIU DOCUMENT FIELD: entereDBY-B- CONDITION: = EQUALS -B- EQUALS NEW PERSON: kstTOPPENBERG,KEVIN Skst 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: [TMGSET(Mar 20,[EMAIL PROTECTED]:09)User #73 File #8925 SEARCH DATA ALREADY STORED THERE....OK TO PURGE?NO// yYESDESCRIPTION: This can be used to store sets of records,forworkingwith 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 SEARCHMAR20,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,notwithFileMan. Look at the ENTERED BY field in yourrecord 4299.If it were reflecting a=== 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 realusers.Discover which products truly live up to the hype. Start readingnow.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-- Greg Kreis http://www.PioneerDataSys.com "You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you." (James Lane Allen)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 Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members |
- Re: [Hardhats-members] Another example of Fileman Search ... Greg Kreis
- Re: [Hardhats-members] Another example of Fileman Se... Nancy Anthracite
- [Hardhats-members] Future of Fileman (was: ...se... Greg Woodhouse
- Re: [Hardhats-members] Future of Fileman Greg Kreis
- Re: [Hardhats-members] Another example of Fileman Se... Greg Woodhouse
- Re: [Hardhats-members] Another example of Fileman Se... Kevin Toppenberg
- Re: [Hardhats-members] Another example of Filema... Greg Kreis
- Re: [Hardhats-members] Another example of Fi... Kevin Toppenberg
- Re: [Hardhats-members] Another example of Fileman Se... Kevin Toppenberg
- Re: [Hardhats-members] Another example of Filema... Greg Woodhouse
- Re: [Hardhats-members] Another example of Fileman Se... Kevin Toppenberg