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,392 of 9,834    |
|    Tony McGuire to All    |
|    Re: Query to find just alpha chars?    |
|    30 Mar 07 08:45:07    |
      From: png.paradoxcommunity@com              Is this a limit of pdoxDOS?              ..a.. or ..b.. or              would work in pdoxWIN I think. With 26 alpha characters (potentially) to       search out you may need more than one query, but...              Still, I think a scan might be easier.              stAlpha="abcdefghijklmnopqrstuvwxyz"       for i from 1 to stAlpha.size()        arArray.addlast(stAlpha.substr(i,1)       endfor              scan tablename :        for x from 1 to arArray.size()        if search(tablename."FieldName",arArray[x])>0 then        ;process, match of alpha found        endif        endfor       endscan              This is pdoxWIN of course, but likely translatable to pdoxDOS without much       modification.                     ---------------------------------------------------------        Tony McGuire              --- 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