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,799 of 9,834   
   JoeSpareBedroom to All   
   Problem with LEN() function   
   22 Oct 10 09:31:49   
   
   From: newstrash@frontiernet.net   
      
   Pdox 4.5 for DOS   
      
   I'm scanning a field formatted as A12, which contains UPC codes (all   
   digits). Any record with 10 characters or less is valid, and I simply want   
   to know how many records are like that. I aimed the code below at a test   
   copy of my table. When it was done, it RETAINED a lot of records which were   
   <11 chars. Checking some of those in field view, I see no hidden chars. What   
   might be causing this?   
      
   Incidentally, if I change the LEN() test to >10, it still doesn't function   
   correctly. This script is purely informational. I simply need to know how   
   many records (out of 18,000) need "treatment". If it's a dozen, I'll ignore   
   them. If it's "a lot", I'll take other action.   
      
      
   tname.a = "c:\\eval\\dump"   
   VIEW tname.a   
   MOVETO [UPC]   
   EDITKEY   
   SCAN   
   IF LEN([])<11   
   THEN   
   DEL   
   ENDIF   
   MESSAGE "Checking field length ",RECNO(), " of ", NRECORDS(tname.a)   
   CANVAS ON CANVAS OFF   
   ENDSCAN   
   DO_IT!   
      
   --- 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