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,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