And you don't think I've ever miscounted and put a parameter in the wrong position?? It's an easy thing to do (and probably the first thing I checked, too). I wouldn't worry about it.
--- Kevin Toppenberg <[EMAIL PROTECTED]> wrote: > 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 > ===== A practical man is a man who practices the errors of his forefathers. --Benjamin Disraeli ==== Greg Woodhouse [EMAIL PROTECTED] [EMAIL PROTECTED] ------------------------------------------------------- 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
