From: pnews@sendto.org   
      
   "Jim Moseley"  wrote in message   
   news:492d9731$1@pnews.thedbcommunity.com...   
   >   
   > Joseph,   
   >   
   > Bertil recently posted about a similar problem.  If you use the 'Check'   
   > option,   
   > you cause an Order By and a Sort, IIRC.  This might run into the limits of   
   > the table size.  Does it work with 'CheckPlus'?   
      
   I was not able to get the query to work with CheckPlus, either with all   
   fields changed from Check to CheckPlus or else just the JobItem fields.   
      
   > What is your default BDE block size (of your answer table)?   
      
   I do not get an answer table, but the default block size of the BDE is 4096.   
      
   > How many rows are in :priv:Whs1.db?   
      
   That table has 115 rows and JobItem.DB has 1050412 records. The issue is   
   that if Whs1.db has only a single JobKey in all of its rows, the query will   
   run successfully. When a second JobKey is added, then the error occurs. I do   
   not believe table size is an issue here because this query will only use a   
   small number of the JobItem records, at most a few hundred.   
      
   I am now getting more interactive information since I added the answer   
   table. "Corrupt file - other than header." Table: JobItem.db   
   File:JobItem.px. However, the PX file is not corrupt. It has been rebuilt   
   with both Chimney Sweep and alternately with TUtility. A TUtility verify   
   reports a BTree error, and Chimney Sweep reports no errors. I do not believe   
   this table is corrupted because the data is heavily used elsewhere and there   
   is no erroneous data reported. I think this is related to this query.   
      
   Thanks,   
   Joe   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)