Greg, You're right. I did format those parameters incorrectly in that screen log. It was good of you to spot that.
So I went back to my upload code that wasn't working. I check to see if I had then out of order, and in my formal code, I didn't. To make a long story short, my upload system was setting the search name to be: 'DOE,JOHN G ' <-- note extra space at the end. That is what was putting Fileman off. I'm not sure if this makes me trust Fileman more, or less... :-) I appreciate your help. Debugging can be painful sometimes, and it helps to have a second set of eyes. Thanks Kevin --- Greg Woodhouse <[EMAIL PROTECTED]> wrote: > Well, the command you used was > > GTM>do > FIND^DIC(2,"","",Fields,value,"*","","","","Matches","TMGMsg") > > The paramters are simply not in the right positions. > My opinion is that > there are simply too many parameters here (easy to > get wrong), but the > DBS calls are designed to use parameter passing > rather than putting > input or output variables in the symbol table > (something I DO like). > > Here's the prototype from the Fileman programmer > manual > > FIND^DIC(FILE,IENS,FIELDS,FLAGS,[.]VALUE,NUMBER,[.]INDEXES,[.]SCREEN, > IDENTIFIER,TARGET_ROOT,MSG_ROOT) > > You have the file number in the correct position and > then rightly skip > the IENS (it is only needed here if you're looking > for entries in a > subfile), the next field is flags (you probably want > "M" for > multi-index lookup), the NEXT field is is the value > for which you are > searching (you skipped one, which is easy to do). __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
