home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,510 of 9,834   
   Joseph Misko to All   
   Strange query error   
   26 Nov 08 12:41:38   
   
   From: pnews@sendto.org   
      
   I have a QBE file that will run fine under many circumstances, but when   
   there is more data in the first table (the second table is not changing   
   right now), then the query errors. The actual query is pasted below from the   
   QBE file.   
      
   1. In code, the return value is false with no additional information on the   
   stack.   
   2. When run directly from ProView, it gives error "Expecting a column   
   separator in table header" (immediately, the query does not even begin to   
   run).   
   3. When opened in design view and run, the query begins to execute and the   
   progress bar displays for about 10 full seconds and then it gives error   
   "Corrupt file - other than header."   
      
   I am not able to make sense of this situation, but if anyone else has   
   experienced something similar to this and has a suggestion, I would   
   appreciate it. Neither of these files are corrupt.   
      
   Many thanks,   
   Joe   
      
   Query   
      
   :PRIV:Whs1.db | JobNum | JobKey                              | JobFgKey |   
                 | Check  | Check _partjk!, _prmjk!, _rawmatjk! | Check    |   
      
   :PRIV:Whs1.db | PartNum         | PrmNum         | RawMatNum         |   
                 | Check _partdim! | Check _prmdim! | Check _rawmatdim! |   
      
   JobItem.DB | JobKey    | ItemNum    | Thickness                |   
              | _partjk   | _partdim   | Check as PartThickness   |   
              | _prmjk    | _prmdim    | Check as PrmThickness    |   
              | _rawmatjk | _rawmatdim | Check as RawMatThickness |   
      
   EndQuery   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca