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 8,110 of 9,834   
   Ed Nash to Craig   
   Re: Why doesn't this work   
   29 Jan 07 10:30:35   
   
   From: ask.me@specifically.pls   
      
   Craig wrote:   
   >  Scan TC2 for TC2."Checkbox" = "Y":   
   >    msginfo(TC2."ClinicalCode",TC2."CheckBox")   
   >    siCount = siCount +1   
   > ENDSCAN   
   >   
   > The reason for the lockrecord is because it wouldn't postrecord() because   
   > the record was not locked.   
   > It always skips the last checkbox. Why?   
   >   
   > Thanks in advance   
   >   
   > Craig   
   >   
   >   
      
      
   Have you tried doing a query instead?  It may be just as fast, or   
   faster, than a scan for this.  Or, you could put a secondary index on   
   CheckBox, then do a setRange(), then tc.nRecords().   
      
   --- 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