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