For starters I'd try INVOICE = FIELD(@ID,'.',3,2) ro...@optonline.net wrote: > AIX 5.3 Universe 10.2.4 300+ user license > > Moved from older aix/universe 9.5 to current one in September 2008. > No index problems. > > File contains 1.5 million records. key = company number * customer > number.xx.invoicenumber.invoicesubnumber. > so the key looks like > 01*123456.IN.10000123.2 > 01*123456.IN.10000123.3 > > The invoice number should be unique, except for the subnumbers. > dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2) > > On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0 records. Other > SELECTS seemed to work. The keys are clean, no special characters. > SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records? > > I did a build.index file on Tuesday morning. didnt work. > Late Tuesday evening, I deleted the index and recreated it and then rebuilt > it. didnt work. > I also copied the contents of the file and the dictionaries from one file to > a new one. recreated and rebuilt the index. so no luck. > > There are no error messages. nothing reported when files were copied. same > number records before and after. > > Any thoughts? > Tonight I'll try a universe shutdown and restart. > > Thanks. > Roger Glenfield > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > >
-- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com /"Come To The Dark Side, We Have Cookies."/ ------------------------------------------------------------------------ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/