Thanks Steven and Chuck. See below On 7/8/06, Steven McPhelan <[EMAIL PROTECTED]> wrote: > ... > > Kevin, why write code when Fileman has tools to do what you are trying to > do. As Chuck stated, for B indexes, you must first reindex the main B index > and then reindex any Mnemonic whole file indexes. You should then have a > properly constructed B index on a file.
Well, I got it working with my code posted, but I am glad to see that I could have done it the proper way. I appear to have reinvented the wheel (again). I had assumed that reindexing the "B" index of the subfile ALIAS would only reindex one given record, not scan through the entire file and take care of all aliases. Thanks! > You also made the statement: "I wonder if the lookup in CPRS is not more > sophisticated than a simply fileman lookup" Whoever said that CPRS even > uses Fileman as his main lookup tool? Well, that's a good point. But in this case it does seem to be true. As soon as I manually added back the alias entries into the "B" index for the PATIENT file, then lookup by alias started working again in CPRS. I guess they might be doing their own lookup, and not using fileman, but either way, is uses that "B" index. Thanks everyone! Kevin ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
